Oracle-L: Unaccounted-for elapsed time

From: Paul Baumgartel <treegarden_at_yahoo.com>
Date: Tue, 28 Oct 2003 08:54:28 -0800
Message-ID: <F001.005D4D17.20031028085428@fatcity.com>

I've been a believer in response-time-based performance optimization for some time now, and reading Cary Millsap's book has reinforced my belief. That said, I'm looking for some help in identifying what I _think_ is unaccounted-for elapsed time.

Both tkprof and trcanlzr show (sorry for the wrapped lines):

call        count       cpu   elapsed         disk        query     
current         rows    misses

------- --------- --------- --------- ------------ ------------ ------------ ------------ ---------

Parse          90      0.02      0.01            0            0        
   0            0         1
Execute        45      0.09      0.09            0           24        
   0            0         1
Fetch          45      4.11     28.20            0        13210        
   0           45         0

------- --------- --------- --------- ------------ ------------ ------------ ------------ ---------

total         180      4.22     28.30            0        13234        
   0           45         2

And the waits

Event                                                                
Times     Count      Max.     Total    Blocks
waited on                                                           
Waited Zero Time      Wait    Waited  Accessed
-----------------------------------------------------------------
--------- --------- --------- --------- ---------
SQL*Net message from client (idle)...............................      
225         0      0.01      0.56
SQL*Net message to client (idle).................................      
225         0      0.00      0.00
-----------------------------------------------------------------
--------- --------- --------- --------- ---------
total............................................................      
450         0      0.01      0.57         0

non-idle waits...................................................      
  0         0      0.00      0.00         0
idle waits.......................................................      
450         0      0.01      0.57

Now, the SQL statement that produced this output makes a couple of function calls...does the elapsed time here include the waits that the function calls might cause? I have 24 seconds of elapsed that aren't accounted for.

TIA,

Paul Baumgartel
Transcentive, Inc.
www.transcentive.com

Do you Yahoo!?
Exclusive Video Premiere - Britney Spears http://launch.yahoo.com/promos/britneyspears/
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Paul Baumgartel
INET: treegarden_at_yahoo.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 Tue Oct 28 2003 - 10:54:28 CST