Barb, This is a great example of where reading the trace file will tell you what you need to know. Is the 10 centiseconds of time in 8 1.25 centisecond events or in 1 10 centisecond event and 7 .1 centisecond events? The location (parse/execute/fetch/post tx) are also important.
Daniel Barbara Baker wrote: > Hi. > I'm running tkprof on my PC with a version 9i client. > The trace file was generated on a Solars version > 8.1.7.4 database. (I'm using tkprof on 9i to get wait > statistics.) The trace is 10046 level 12 > > I assume the time waited is in addition to the elapsed > time for the call -- correct? > > Since the database itself is 8i, does that mean that > the wait stats are in centiseconds? I want to know > what the sql*net message from client wait time of > 10.73 represents: > > Elapsed times include waiting on following events: > Event waited on Times Max. Wait Total > Waited > -------------------- Waited ---------- --------- > SQL*Net message to client 8 0.00 0.00 > SQL*Net message from client 8 10.71 10.73 > > Here's all the code: > > select /*ClassSQL*/ distinct co.class,cl.claname > from > classorder co,class cl where co.paper='DNA' and > co.page='EM' and co.class= > cl.class and co.paper=cl.paper and cl.clatype='0' > order by 1 > > call count cpu elapsed disk > query current rows > ------- ------ -------- ---------- ---------- > ---------- ---------- ---------- > Parse 1 0.01 0.01 0 > 0 0 0 > Execute 1 0.00 0.00 0 > 0 0 0 > Fetch 8 0.01 0.01 0 > 169 0 82 > ------- ------ -------- ---------- ---------- > ---------- ---------- ---------- > total 10 0.02 0.02 0 > 169 0 82 > > Misses in library cache during parse: 1 > Optimizer goal: CHOOSE > Parsing user id: 586 (SYSADMIN) > > Rows Row Source Operation > ------- > --------------------------------------------------- > 82 SORT UNIQUE > 82 NESTED LOOPS > 83 INDEX RANGE SCAN (object id 395118) > 82 TABLE ACCESS BY INDEX ROWID CLASS > 164 INDEX UNIQUE SCAN (object id 395113) > > Rows Execution Plan > ------- > --------------------------------------------------- > 0 SELECT STATEMENT GOAL: CHOOSE > 82 SORT (UNIQUE) > 82 NESTED LOOPS > 83 INDEX GOAL: ANALYZED (RANGE SCAN) OF > 'I_CLO1' (NON-UNIQUE) > > 82 TABLE ACCESS GOAL: ANALYZED (BY INDEX > ROWID) OF 'CLASS' > 164 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF > 'I_CLA1' (UNIQUE) > > Thanks for any help. > > Barb > > __________________________________ > Do you Yahoo!? > Protect your identity with Yahoo! Mail AddressGuard > http://antispam.yahoo.com/whatsnewfree > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Barbara Baker > 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Fink 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).
