Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> tkprof - disk reads greater than query+current

tkprof - disk reads greater than query+current

From: <wagen123_at_yahoo.com>
Date: 20 Apr 2007 10:58:14 -0700
Message-ID: <1177091894.510369.289760@b58g2000hsg.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US