Title: RE: What to check?
David,
I'd check that they are using the same exact script on all three machines.
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: Nguyen, David M [SMTP:[EMAIL PROTECTED]
Someone
Title: RE: What to check?
All three machines having the same amount of CPUs and memory, and he uses the same script to run on three machines, some of tables containing hundred thousands of records. Below is a portion of his script. Is there a way to improve his SQL command?
@Dumptables.sql
:
[EMAIL PROTECTED]Subject: RE: What to check?
Sent
David,
Have you checked the most obvious... The number of rows in the table?
Also, you say three different Solaris8 machines... How different are
they? Are the disk subsystems the same on all three? How identical are
their configurations? How similar are the init.ora files on all three
David,
You need to see what is taking all the time on the 'slow' machine.
Ask the person with the script to put this at the top of the script
for the next run:
alter session set events '10046 trace name context forever, level 8';
Explanation of level:
-- level 4 is bind values
-- level 8 is
Are they dumping the table over the network or locally?
If it's over the network, then probably there is a slow network connection
or/and small array fetch.
Checking the number of fetches in a trace/tkprof file could help.
Also pre-compiled languages have many bugs that disable array fetch.
Nguyen, David M wrote:
Someone writes a SQL script to dump a table on three different
database on three different Solaris8 machines, he complaines one of
machines took 6 hours to dump a table while other two's only take one
hour. He asks me to investigate why. I log into the machine in
The wait events.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Fri, 28 Feb 2003, Nguyen, David M wrote:
Someone writes a SQL script to dump a table on three different database on
three different Solaris8 machines, he complaines one of machines took 6
hours to dump a table while
by Jared.
- Kirti
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, September 05, 2001 7:20 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: what to check in alert.log
Alex,
Here's what I currently look
I check for these strings:
ORA-
TNS-
trc
cannot
exceeded
That works well for me.
Systems Admin Operations | Admin. et Exploit. des systèms
Technology Services | Services technologiques
Informatics Branch | Direction de l'informatique
Maritimes Region, DFO | Région des
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Arich Henneman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Arich Henneman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
Alex,
Here's what I currently look for:
At the begging of a line ORA or TNS
Anywhere in the line 'crash' or 'recovery';
Sometimes generates more mail than I care for. :)
Jared
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Arich Henneman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Arich Henneman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
I also add 'corrupt' in the list by Jared.
- Kirti
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, September 05, 2001 7:20 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: what to check in alert.log
Alex,
Here's what I
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Arich Henneman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
please turn off the autoresponder(or doing it manually) and sending
empty messages.
joe
Arich Henneman wrote:
--
Joe Testa
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
IM: n8xcthome or joen8xct
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Arich Henneman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Arich Henneman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
20 matches
Mail list logo