Re: What to check?

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 machines (perhaps sort_area_size or something similar depending on the query to dump the table)? Unfortunately there's a lot of possibilities about what might cause the slow down.

The other suggestions of wait events and execution plans are valid ideas. Hopefully one of these will give a hint about where to look for the cause.

Regards,

     Mark.

                                                                                                                   
                    "Nguyen, David                                                                                 
                    M"                   To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>       
                    <david.m.nguye       cc:                                                                       
                    n_at_xo.com>            Subject:     What to check?                                               
                    Sent by:                                                                                       
                    root_at_fatcity.c                                                                                 
                    om                                                                                             
                                                                                                                   
                                                                                                                   
                    01/03/2003                                                                                     
                    08:09                                                                                          
                    Please respond                                                                                 
                    to ORACLE-L                                                                                    
                                                                                                                   
                                                                                                                   

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

<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

   Privileged/Confidential information may be contained in this message.

          If you are not the addressee indicated in this message
       (or responsible for delivery of the message to such person),
            you may not copy or deliver this message to anyone.
In such case, you should destroy this message and kindly notify the sender
           by reply e-mail or by telephone on (61 3) 9612-6999.
   Please advise immediately if you or your employer does not consent to
                Internet e-mail for messages of this kind.
        Opinions, conclusions and other information in this message
              that do not relate to the official business of
                         Transurban City Link Ltd
         shall be understood as neither given nor endorsed by it.
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mark Richard
  INET: mrichard_at_transurban.com.au

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).