Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> tkprof - disk reads greater than query+current
Hi,
Oracle10g 10.1.0.3
call count cpu elapsed disk query current rows
Parse 1 0.09 0.93 9 963 0 0 Execute 1 0.02 0.40 0 18 0 0 Fetch 3 2.05 11.40 11352 7909 0 21
total 5 2.16 12.74 11361 8890 0 21
Can anyone help me understand why disk reads is greater than query +current?
Thanks
wagen
Received on Fri Apr 20 2007 - 12:58:14 CDT