tkprofed scatter read time

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

  ---

  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

--

http://www.freelists.org/webpage/oracle-l Received on Thu Oct 30 2008 - 07:07:55 CDT