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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
