We are doing a Benchmark on RAC with Digital Unix (Tru64 Unix) with Oracle 9.0.1.3
Any Dos , Don'ts , Advice , Links , Books for MAXimizing Performance ?
Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: VIVEK_SHARMA
INET: [EMAIL PROTECTED]
Fat City Network
Qs How is Select of Data from a Long Datatype Field to INSERT into a Varchar2 Datatype
Field
in another Table possible ?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: VIVEK_SHARMA
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858)
Hi all!
Can you guys, clear me up about what are the tasks of a database analyst. I
mean something like a job description.
I know they are likely to be different from case to case but just to make an
ideea.
Thanks in advance.
Iulian Ilies
Apart from explicity running an ANALYZE command against a table, what, if
any, other events/actions can cause an analyze to be run on the table?
-
Seán O' Neill
Organon (Ireland) Ltd.
[subscribed: digest mode]
DBO, its not about a smell.
On 23 Jul 2002 at 10:28, Mercadante, Thomas F wrote:
... (you lost me at hallo)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Eric D. Pierce
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858)
Oops, missed a quotation mark in earlier posting. Should have read:
sqlplus -s / EOF | grep -v ^$ | sed -n '$p'
select sysdate from dual;
exit
EOF
Regards
Chris
-Original Message-
Sent: 24 July 2002 09:15
To: '[EMAIL PROTECTED]'
Ross,
You are hitting a couple of problems here:
long response
My opinion that shutdown abort is totally safe is
based on this:
The only thing that matters in the database is redo
logs. Everything else is optional - ie it could be
recovered albeit with difficulty (eg you can recreate
a controlfile from scratch if you really have to, and
are you talking about reinstalling windows, or oracle?
did you take it down to bare metal, and remove all
oracle products, including following the instructions
from oracle tech support for doing a manual cleanout?
do you have a production db installed on that box?
backups?
On 23 Jul 2002
An export has default parameter of STATISTICS=ESTIMATE.
If such an exported file is imported , the default import
parameter ANALYZE=Y will result in the import utility
executing the analyze stmts in dump file.
-Original Message-
Sean
Sent: Wednesday, July 24, 2002 2:33 PM
To: Multiple
Ross,
Not sure if original mail got through (looked garbled on Fatcity website) so
here goes again
You are hitting a couple of problems here:
1 - the 'tail' command needs to be on your first line (sqlplus / EOF |
tail -1)
2. However, I suspect this will not give you what you want as
Title: shutdown abort / startup restrict / shutdown vs. shutdown immediate
Couldn't agree with you more. I recently had a
database fail to restart after a shutdown abort because the redo log got
corrupted somewhere along the line. Ended up doing a full restore and roll
forward. Admittedly,
Ross,
You are hitting a couple of problems here:
1 - the 'tail' command needs to be on your first line (sqlplus / EOF |
tail -1)
2. However, I suspect this will not give you what you want as sqlplus
prints a blank line at the end. Try the following:
sqlplus -s / EOF | grep -v ^$ | sed -n
print
conn / as sysdba
select some_stuff..
exit | sqlplus /nolog | tail -1
hth
connor
--- Ross Collado [EMAIL PROTECTED] wrote:
Hi all,
Can any of our Unix gurus here transform my script
below to work properly?
The intention is to print the last line of the
sqlplus output.
With set
dbms_stats
--- O'Neill, Sean [EMAIL PROTECTED] wrote:
Apart from explicity running an ANALYZE command against a table,
what, if
any, other events/actions can cause an analyze to be run on the
table?
-
Seán O' Neill
Organon (Ireland) Ltd.
[subscribed: digest
what is dual?
On 23 Jul 2002 at 10:53, Farnsworth, Dave wrote:
... The rest of us are just goofs.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Eric D. Pierce
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San
If you can take the database down for 1.25 hours.
I will hesitate to startup the database with time
less then last closing time.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, July 22, 2002 8:33 PM
Hi Guys,
I need
I get the following output:
spauser sh kev.sh
+ sh kev.sh
SQL*Plus: Release 3.3.2.0.0 - Production on Wed Jul 24 09:22:05 2002
Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.
Connected to:
Oracle7 Server Release 7.3.2.3.0 - Production Release
With the distributed and
Hmm, this still doesn't seem to work.
-Original Message-
Sent: 24 July 2002 10:38
To: Multiple recipients of list ORACLE-L
Oops, missed a quotation mark in earlier posting. Should have read:
sqlplus -s / EOF | grep -v ^$ | sed -n '$p'
select sysdate from dual;
exit
EOF
Regards
No Impact. Analyze would just collect the latest statistics for the
concerned table and the next time any query gets fired on this table the
optimizer (CBO) would generate the execution plan based on these statistics.
I also believe that this would be healthier sign as the CBO is generating
DBMS_STATS can be used to analyze tables.
Dave
-Original Message-
Sent: Wednesday, July 24, 2002 4:03 AM
To: Multiple recipients of list ORACLE-L
Apart from explicity running an ANALYZE command against a table, what, if
any, other events/actions can cause an analyze to be run on the
All,
Can anyone provide examples of how to issue an SQL statement in VB using
Bind Variables (using DAO or ADO).
Many thanks for any responses.
Dave Leach
Technical Services
Claybrook Computing
Internal ext * 4992
Phone * 01293 604992
Fax 01293 604029
E-Mail * [EMAIL PROTECTED]
The above
Leslie,
It appears that there is an action occuring on your database at 18:20
each day that needs the tablespace that was deleted. It might be a
scheduled job or an application that is external to the server. try
restoring the tablespace from your backup and see if the errors
continue.
I also
Oracle will continue to work fine (as it uses SCN numbers for consistency and
transaction logging rather than dates). However, if you have any apps which use
timestamps in the data, then I'd do some more investigation for the ramnifications on
the application logic side...
-Original
A question:
If analyzing SYS objects is a bad idea, why is it included by default in the
analyzing commands (dbms_stats, analyze, dbms_utility.analyze_database)?
Please correct me if my assumption is wrong, we had strange behaviour here
when SYS objects were analyzed on a development db.
Dual is a dummy table which oracle has provided to retrieve the values of
Environment Variables.
eg. Select user from dual;
Select sysdate from dual; and many other manipulations like
Select 12 * 12 + 3 from dual;
As the ANSI/SQL syntax requires FROM Clause so that's the reason Oracle
Dennis , thanks for your suggestions.
It seems detection is the only viable option to avoid locking.
i'll try to get the suggested book from somewhere .
ratnesh
-Original Message-
WILLIAMS
Sent: Tuesday, July 23, 2002 9:08 PM
To: Multiple recipients of list ORACLE-L
Ratnesh
I
Oracle has no concept wrt. the date time of Operating System for running
individually as a product. It just takes the timestamp in certain DML's
while updating and inserting the rows having DATE as datatype. Nothing more
than this.
Oracle works on the mechanism of SCN ie. System Change
Title: RE: View error msg
Take a look at Note:93516.1 on Metalink (Can a View be Created That Allows
Insert of Records into the View and Base Table). Make sure that one table
has a primary key that is reference by a fk in the other table. Without the
relationship, it won't work, hence the
Does the WHERE clause on your view contain all of the fields from both
primary keys? Maybe you should post the table/view definitions.
Beth
-Original Message-
Sent: Tuesday, July 23, 2002 11:33 PM
To: Multiple recipients of list ORACLE-L
Hi,
I created a view as a join of
yes , but time based incomplete recovery could create problems if he doesnt
take a full
backup after the os-time-change .
-Original Message-
Sent: Wednesday, July 24, 2002 6:39 PM
To: Multiple recipients of list ORACLE-L
Oracle has no concept wrt. the date time of Operating System for
On Tue, Jul 23, 2002 at 10:38:18PM -0800, Gogala, Mladen wrote:
No, it's not certified, but I know the guy who successfully installed
9.2 on the cooker. Certificates are of limited value in the Linux world.
Production support might be of interest, someday, in the linux world.
I'd hate to
Title: RE: Unix Q: ksh scripting
With the addition of the extra quote...this worked fine for me. Kevin,
try running it using the korn shell ( ksh instead of sh - bourne shell).
If you're just trying to grab the date, though, I'd do it like this:
#!/bin/ksh
THE_DATE=`sqlplus -s / EOF
set
It works for me. Using the following code:
#!/bin/ksh
#set -x
sqlplus / EOF | tail -1
select sysdate from dual;
exit
EOF
I get:
$ test.sh
JServer Release 8.1.7.0.0 - Production
$
With -x flag set:
$ test.sh
+ tail -1
+ sqlplus nri/nri
+ 0 /tmp/sh27884.2
JServer Release 8.1.7.0.0 -
BTW, 9iAS is not required for OWB. I'm running it on a 9.0.1 database
with no 9iAS. You lose a couple of features, but nothing major.
Beth
-Original Message-
Sent: Wednesday, July 24, 2002 5:58 AM
To: Multiple recipients of list ORACLE-L
are you talking about reinstalling windows,
On Wed, Jul 24, 2002 at 04:48:41AM -0800, Boivin, Patrice J wrote:
A question:
If analyzing SYS objects is a bad idea, why is it included by default in the
analyzing commands (dbms_stats, analyze, dbms_utility.analyze_database)?
bug, Doc ID: 203003.996, fixed in 9i...I hate it when that
The
optimizer will use the availability of indexes in deciding which type of join to
use.
no
indexes = merge join
indexes = nested loops, although the optimizer may
dynamically choose to perform a hash join.
Your
tweaking of the join conditions is what causes the different joins to be
Title: RE: Unix Q: ksh scripting
I also assumed you may want the last line (rather than
just sysdate) - grep -v ^$ | sed -n '$p' solution works for last
line too :)
-Original Message-From: Richard Huntley
[mailto:[EMAIL PROTECTED]]Sent: 24 July 2002
14:49To: Multiple
Title: RE: Converting Longs
Jay,
Well since he says Oracle recommends not using Longs but Oracle itself uses Longs, have the luser submit a TAR or give him Uncle Larry's email address. Should be good for a laugh or two.
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL
From: Eric D. Pierce [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 24, 2002 4:58 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Windohs client problems
are you talking about reinstalling windows, or oracle?
did you take it down to bare metal, and remove all
oracle
I get no hits when I try to see bug 203003.996 in Metalink.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique
OK, I posted this Monday, went fishing yesterday and figured I'd hear
something about this today but nothing... has anyone even heard of GFS?
Sistina? Raw? Cluster File Systems? :-)
-Original Message-
Sent: Monday, July 22, 2002 6:18 PM
To: Multiple recipients of list ORACLE-L
I'd just do:
$ date
;o)
-Original Message-
Sent: 24 July 2002 14:49
To: Multiple recipients of list ORACLE-L
With the addition of the extra quote...this worked fine for me. Kevin,
try running it using the korn shell ( ksh instead of sh - bourne shell).
If you're just trying
Hello:
Is there anyway to find the size of a cursor in bytes?
We are attempting to implement ADO returning Oracle cursors and want to make
sure we are not returning more then the 64k limit.
Thank you in advance,
Jay
_
MSN Photos
On the subject on analyzed:
We are doing analyze compute statistics and it takes about an hour.
Do you know of ways to speed it up?
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 24, 2002 3:54 PM
On Wed, Jul
# !/bin/ksh
# set -x
sqlplus / EOF
select sysdate from dual;
exit
EOF | tail -1
The close needs to be on a line by itself:
(
foo - BAR
stuff here
BAR
) | tail -1;
will do what you want.
--
Steven Lembark 2930 W. Palmer
We are doing a Benchmark on RAC with Digital Unix (Tru64 Unix) with Oracle 9.0.1.3
Any Dos , Don'ts , Advice , Links , Books for MAXimizing Performance ?
Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: VIVEK_SHARMA
INET: [EMAIL PROTECTED]
Fat City Network
Srinath,List
Can you give some Detail ?
Thanks to All
-Original Message-
Sent: Wednesday, July 24, 2002 12:31 PM
To: LazyDBA.com Discussion
Dat atype Field
You can do this in PL/SQL, not in SQL/Plus
-Original Message-
From: Ganesh Raja [SMTP:[EMAIL
To wit:
$grep -i grant spctab.sql
grant select on STATS$SNAPSHOT_ID to PUBLIC;
grant select onSTATS$DATABASE_INSTANCE to PUBLIC;
grant select onSTATS$SNAPSHOT to PUBLIC;
grant select onSTATS$FILESTATXS to PUBLIC;
grant select onSTATS$TEMPSTATXS to
Hi
I am trying to find estimated size for a view using
DBMS_OLAP.ESTIMATE_SUMMARY_SIZE package.
Using the following sql (logged in as SYS). I am new
to materialized views
and DBMS_OLAP.ESTIMATE_SUMMARY_SIZE usage.
I am doing this through SQL*Plus logged in as SYS.
I also set SERVEROUTPUT ON
That is EXACTLY what happened a week and a half ago. We had to do a
shutdown abort because it wouldn't go down, and when we tried to restart it,
it wouldn't come back... redo log corruption... and this being test... it
isn't in archive log mode (another valid solution but no longer really an
On Wed, Jul 24, 2002 at 06:53:34AM -0800, Boivin, Patrice J wrote:
I get no hits when I try to see bug 203003.996 in Metalink.
I do, try the advanced search, maybe.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des
If you don't mind, under what version/os did this take place?
On Wed, Jul 24, 2002 at 07:28:40AM -0800, April Wells wrote:
That is EXACTLY what happened a week and a half ago. We had to do a
shutdown abort because it wouldn't go down, and when we tried to restart it,
it wouldn't come
Could anyone share their Unix script to age the listener log file? I know
that this has been posted to the group in the past, but I was unable to find
it in the archives at FatCity.
Thanks.
Erik
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Erik Williams
INET:
What is the longest SQL statement that can be analyzed via explain plan. Is it the
maximum length equal to the maximum length of a varchar2. Does the new virtual
explain view have any problems with the length of the statement?
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL
I think they may have some flawed processes because my wife received one
piece of mail from them and we are more than a few years younger than
50. But Rachel, in my mind there's no way you would be even close to
qualifying for their benefits.
Stephen
[EMAIL PROTECTED] 07/23/02 11:38AM
what a
Upgrades? We don't need no stinking upgrades... because this is a test
setup. I'd figured on making ORACLE_HOME local for production for that same
reason. The NetApp install doc makes it sound like an absolute requirement
without explaining the reasoning.
Always the documentation critic...
Vivek - Hopefully you will receive some replies from someone with RAC
experience. However, since RAC is so new, the information on tuning it may
be pretty slim. Since RAC is based on Oracle Parallel Server, you might
consider searching for tips on OPS. Some tips might apply to RAC.
Dennis
I think that you will understand it better if you consider 2 scenario's:
1) RMAN backup from time 13:00 is newer then the backup taken at 13:45.
2) You get Enron accounting when the feds discover that invoice number 123
was issued after invoice 124.
There are a lot of things, application and /
Hi Oracle gurus:
Old db question: best db file layout accross filesystems/disks. (unix - Solaris 2.8,
Oracle 8.1.7.4)
I have inherited a db file layout recommendation that says to put oracle software and
db system tablespaces on the same filesystem /u00/
This is for a production system and
Make a copy of the file appended by the Julian date then empty the log via
cat /dev/null listener.log. (You don't really need a cat.)
-Original Message-
Sent: Wednesday, July 24, 2002 9:50 AM
To: Multiple recipients of list ORACLE-L
Could anyone share their Unix script to age the
I posted this answer once before.
How about wrapping this is a script of your choice:
ARCHIVE_LISTENER_FILENAME=listener`date +%Y%m%d%H%M`.log
lsnrctl set log_file listener2.log
mv listener.log $ARCHIVE_LISTENER_FILENAME
mv listener2.log
Yechiel
Consider ANALYZE TABLE ESTIMATE STATISTICS.
If you consider sampling theory, with larger tables you shouldn't need to
inspect each row. You can vary the number of rows that are sampled. We had a
good discussion on this topic on this list awhile back.
Dennis Williams
DBA
Lifetouch,
Ian:
Any valid SQL statement can be explained. I've explained queries that were
well over 4k -- even when you excluded the whitespace!
Kevin
-Original Message-
Sent: Wednesday, July 24, 2002 11:50 AM
To: Multiple recipients of list ORACLE-L
What is the longest SQL statement that can
Why is it necessary to null out the file? Does LSNR keep a open file handle
open to it?
-Original Message-
From: Orr, Steve [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, July 24, 2002 12:25 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Listener Log Aging Script
Make
what is dummy?
On 24 Jul 2002 at 4:54, Vikas Khanna wrote:
Dual is a dummy table
...
-Original Message-
Sent: Wednesday, July 24, 2002 3:08 PM
To: Multiple recipients of list ORACLE-L
what is dual?
On 23 Jul 2002 at 10:53, Farnsworth, Dave wrote:
... The rest of us
Shut the database DOWN for 1.25 hours?
Who in the heck can afford THAT!
You are *way* off base my friend. If I suggested to my client that they
need to shut the database down because of a time change, they would send me
out on a rail - and I would deserve it.
Bad idea.
Tom Mercadante
Oracle
I looked into the same thing some time ago. I found Oracle papers that
recommend using estimate 25% on the tables and a full analyze on the
indexes.
I wrote the script below to generate a script with all the analyze
statements I needed for the schema to be analyzed. I added date and time
Help me out here, is there a procedure or statement I can use to record
client character set settings in a logon trigger?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Post, Ethan
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858)
exactly.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 24, 2002 10:43 AM
Why is it necessary to null out the file? Does LSNR keep a open file
handle
open to it?
-Original Message-
From: Orr, Steve [SMTP:[EMAIL
OR
# !/bin/ksh
# set -x
sqlplus / EOF | tail -1
select sysdate from dual;
exit
EOF
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
The problem with some people is that when they aren't drunk, they're sober.
--William Butler
Yeats.
Nah wouldn't do it! Ideally you separate everything that improves
performance and recovery chances in the event of a failure and I don't
like the idea of having code and data on the same volume spindles.
Remember that Oracle has to access the admin part of the tree to write
trace files and
Sounds like yet another good reason for using bind variables 8-)
Kevin Kennedy
First Point Energy Corporation
-Original Message-
Sent: Wednesday, July 24, 2002 8:23 AM
To: Multiple recipients of list ORACLE-L
To wit:
$grep -i grant spctab.sql
grant select on STATS$SNAPSHOT_ID
It keeps the file handle to the inode not the filename so when you mv
filea fileb the listener is still writing to the inode which now belongs
to fileb so if you want to move it you need to do the set listener.
On the other hand if you cp filea to fileb then the listener is stilled
pointed at
See John Carlson's answer. You could shut down the listener and delete or
rename the file but why bother when you can just
/dev/nulllistener.log
-Original Message-
Sent: Wednesday, July 24, 2002 10:44 AM
To: Multiple recipients of list ORACLE-L
Why is it necessary to null out the
I imagine it would depend on the application.
Some people are stuck working on 24x7 databases, others are lucky enough to
have a life.
:)
--Walt Weaver
Bozeman, Montana
-Original Message-
Sent: Wednesday, July 24, 2002 10:44 AM
To: Multiple recipients of list ORACLE-L
Shut the
Oracle Apps r10.7 and r11.0 had some SQL statements from PRO*C batch
programs that are over 20K in length. Utterly astounding!
Since VARCHAR2 variables can be up to 32767 in PL/SQL, I've written PL/SQL
packages that used string variables of that length for automating EXPLAIN
PLAN execution and
At the last Open World I attended a couple of sessions
where the general advice for 9i DB is to use ANALYZE
ESTIMATE without specifying ANY value. A few brief
comparision tests did show that it got better results
than the alternatives tested.
As always, YMMV HTH
HAND!
--
Please see the
Jack,
Surprisingly, vmstat provides some idea of OS Waits - look under the 'procs
- r b w' columns (running, blocked, swapped).
John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002
Want to know about a carpenter who built a bridge with two sticks and three
nails? Write me for
SELECT SUBSTR(sql_text, 1, 2000)
FROM sys.V_$OPEN_CURSOR
WHERE UPPER (sql_text) LIKE 'ALTER SESSION%'
with appropriate sid.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any
If you don't want to change your application, get the application booster
from oraperf. That will do it for you ;-)
Setting up one environment variable and run again, this time much faster
..
Anjo.
- Original Message -
To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]
Last try
-Original Message-
Sent: Tuesday, July 23, 2002 2:24 PM
To: Multiple recipients of list ORACLE-L
Hello Listers,
We are about to call veritas for a netbackup businessserver solution for our databases
on hp k570 10.2 boxes
A Veritas Vendor is proposing Netbackup
Interesting...
According to the white papers at their web site it is
not yet certified w/Oracle (they are working on it).
Appears to have been originally developed for some
massive NASA requirement (this is a hunch after
reading their white papers and having some experience
with NASA) like
Dude,
Tisk, tisk, sounds like you didn't read all 25,000 pages of
documentation before starting your install/deinstall/reinstall
hell.
VAX?! Well, the versions of early Oracle products were quite
simple back then, no? Installing Oracle stuff on Netware or
DOS/Windows back in the old days
I suppose that would work if an alter session is used but what if the client
is simply set up to use a different character set, for example if NLS_LANG
is set to something other than the database character set.
export NLS_LANG=Blah
sqlplus foo/bar
Now what character set is being used? I
kthr memory page faultscpu
- --- ---
r b avm fre re pi po fr sr cy in sy cs us sy id wa
0 4 754461 3196 0 15 12 299 242 0 596 448 294 53 17 99 32
0 2 754461 3195 0 0
To ALL,
I'm going to ask if anyone on the list has seen the following, and if so,
what did you do about it if anything.
First environment:
Oracle 8.1.7.4.0 on HP-UX 11.0 both in 64 bit.
OCI interface programs to the database.
Various interfaces done by database links into
Just in case it might matter:
Also note that the Oracle 8.1.7 install docs say under
Deinstalling with the OUI that it is possible for
the OUI inventory to get trashed, and OUI will be
confused about what is and isn't installed.
Not sure if that is the same for the 9.x OUI.
regards,
ep
EP,
What I cannot understand is why you left the fertilizer industry. Based on
your commentary and the state of the economy I suspect demand
could not keep up with your supply. Just kidding your posts are quite
amusing.
I have seen forms do this all the time, i.e. without actually issuing the
'alter session ...' command, you can see they being done. I think it must be
something to do with sqlnet.
Have you tried it yet?
Raj
__
Rajendra Jamadagni
In general, I agree with the majority opinion that seems to be saying that
Oracle chugs along
perfectly happy when the date changes. Time based recovery might have some
issues, so I'd
run a hot after the change so I could use it as my basis in a restore.
The real question in my mind is ... What
Why not just backup the spctab.sql script and then in vi do a g:/PUBLIC/s//DBA or whatever
role you choose to play with statspack before running. Although bind vars are still
appropriate too.
Rodd Holman
On Wed, 2002-07-24 at 12:23, kkennedy wrote:
Sounds like yet another good
Hi Ethan,
I assume this is from an AIX box (right?)
Some remarks: (not an answer!) The first line of vmstat/iostat output is an
average since restart. The 'wa' is 32 and you have 4 processes blocked on
average. Was there a problem (or a large load) since your last restart that
was since solved?
Linux has a top that displays load for each processor.
Is there a solaris version that anyone has seen? Thanks.
===
Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D
--
Please see the official ORACLE-L FAQ:
Hi Friends,
Iam reorganizing my tables thru copy(CTAS), So when Iam re-inserting data
into my Original table Will the indexes will build automatically or I have
to rebuild?? Here Iam not doing for indexes anything i.e Iam not disabling
it.
I want to create table thru CTAS, truncate original
You can download top (and other goodies) from
http://www.sunfreeware.com.
Ray Stell wrote:
Linux has a top that displays load for each processor.
Is there a solaris version that anyone has seen? Thanks.
===
Ray Stell [EMAIL
select sys_context('USERENV','LANGUAGE') FROM DUAL ???
-Original Message-
Sent: Wednesday, July 24, 2002 11:05 AM
To: Multiple recipients of list ORACLE-L
Help me out here, is there a procedure or statement I can use to record
client character set settings in a logon trigger?
--
Depending on whether you wish to humiliate and demoralize
the duhveloper, or you think there may be hope and you wish
to educate him, one of the following may work.
1. Show him the the sys.trigger$ table and point him at documentation
that will help him convert the WHENCLAUSE column to a CLOB
Jack,
TOP adds %wio and %idle together.
Use 'sar -u' instead.
Jared
Jack Silvey [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/23/2002 08:58 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:IO
Well, it's not exactly a secret that our friend Gaja is now working
for Oracle as a Director of Systems Management Tools ( I think
the title is correct ), and that that title would include oversight of
OEM, so I think we can expect good things to happen with OEM.
Jared
Rachel Carmichael
-Original Message-
From: Eric D. Pierce [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 24, 2002 1:07 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Windohs client problems
Dude,
Tisk, tisk, sounds like you didn't read all 25,000 pages of
documentation before
1 - 100 of 152 matches
Mail list logo
