Re: Help Interpreting TKProf

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Daniel Fink
  INET: Daniel.Fink_at_Sun.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).