Re: Have difficulty in understanding the tkprof result

From: chao_ping <chao_ping_at_163.com>
Date: 5 Jun 2002 06:17:50 GMT
Message-ID: <3cfdad0e$7@usenetgateway.com>

another straing thing: This is oracle 8.172 on solaris 7. The tkprof is using oracle9i tkprof on another solaris machine. the wait event is enabled via event 10046 level 8. select JUDGE_ID into :b0 from USERJUDGE where (((PRODUCT_ID=:b1 and AUCTION_ID=:b2) and ((AUCTION_TYPE='A' and :b3=0) or (AUCTION_TYPE='F' and :b3=1))) and CRITIC_IDENTITY=1)

call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.00 0 0 0 0 Execute 1 0.00 0.01 0 0 0 0 Fetch 1 1.83 1.85 769 14020 5 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 1.84 1.86 769 14020 5 1

Misses in library cache during parse: 1 Optimizer goal: FIRST_ROWS Parsing user id: 32

Rows Row Source Operation -------

--------------------------------------------------- 1 TABLE ACCESS

FULL USERJUDGE Elapsed times include waiting on following events: Event waited on Times

Max. Wait Total Waited ---------------------------------------- Waited

---------- ------------ db file sequential read 608 0.01 0.04 db file scattered read 71 0.01 0.01 latch free 1 0.01 0.01 SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00

Since it is full table scan(i did not use explain, so this is the actual execution path), why there is wait event on db file sequential read? and so much time? Crazy !

--
an oracle fan, 
an oracle beginner

an oracle fan, 
an oracle beginner

an oracle fan, 
an oracle beginner

Posted via dBforums
http://dbforums.com

Received on Wed Jun 05 2002 - 01:17:50 CDT