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