Re: tkprof - disk reads greater than query+current

<wagen123_at_yahoo.com> wrote in message
news:1177091894.510369.289760_at_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
>

It would be good to hear something about the SQL. For example, I think it was around that version that a SAMPLE clause would produce this oddity:

    physical reads would be the number
    of blocks reads, query/current would     be the number used for sampling.

-- 
Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com

Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html