tkprofed scatter read time
- From: "LS Cheng" <exriscer@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 30 Oct 2008 13:07:55 +0100
Hi
Does anyone know if the time shown in TKPROFed trace file such as
1168668 TABLE ACCESS FULL KK (cr=24641 pr=24630 pw=0 time=9349586 us)
The time shown can be defect of time drifting issue? Because the query takes
6 seconds and it reports the scatter read took 9 seconds, not very logical
:-)
Thanks
--
LSC
call count cpu elapsed disk query current
rows
------- ------ -------- ---------- ---------- ---------- ----------
----------
Parse 1 0.00 0.00 0 0
0 0
Execute 1 0.00 0.00 0 0
0 0
Fetch 2 1.18 6.19 24630 24641
0 1
------- ------ -------- ---------- ---------- ---------- ----------
----------
total 4 1.18 6.19 24630 24641
0 1
Misses in library cache during parse: 1
Optimizer mode: ALL_ROWS
Parsing user id: SYS
Rows Row Source Operation
------- ---------------------------------------------------
1 SORT AGGREGATE (cr=24641 pr=24630 pw=0 time=6190750 us)
1168668 TABLE ACCESS FULL KK (cr=24641 pr=24630 pw=0 time=9349586 us)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total
Waited
---------------------------------------- Waited ----------
------------
SQL*Net message to client 2 0.00
0.00
db file sequential read 1 0.00
0.00
db file scattered read 209 0.09
6.02
SQL*Net message from client 2 0.00
0.00
Other related posts:
- » tkprofed scatter read time
