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