Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: What to check?
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 waits -- level 12 is both
This will cause those sessions to generate trace files that show the wait times, which should be investigated. There are some notes on MetaLink that explain how to read these.
You can also use tkprof with these files to generate the execution plans of all the SQL involved, as well as a nicely formmated summary of where the time was spent on each statement.
Unless the tkprof output makes the problem obvious, you should probably still check out the raw trace file for details on where the waits are.
HTH Jared
On Friday 28 February 2003 13:09, 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 question to check I/O
> statistic, memory, CPU usage and found no problem. What else should I
> check here?
>
> Regards,
> David
Content-Type: text/html; name="Attachment: 1" Content-Transfer-Encoding: quoted-printable Content-Description: ----------------------------------------
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: jkstill_at_cybcon.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Sat Mar 01 2003 - 19:13:36 CST