Re: Tkprof73 question

[snip biggest part of the explanation]
> The 'disk' statistics show that 100 disk blocks were read from the
> datafiles for the session. The fact that c query buffers were used
> probably indicates that the same data blocks were continually revisited
> throughout the session, not the best situation.
>
> David Fitzjarrell
> Oracle Certified DBA
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

May I ask you a question?
Are you sure about this. I always learned to interpret this as 12329 buffers used *of which only 100* where physical reads. You probably agree that's quite a different way of reading it, in my opinion this would still be an inefficient statement given the ratio of buffer gets and records, but not with respect to physical I/O

Regards,

Sybrand Bakker, Oracle DBA Received on Thu Jun 15 2000 - 00:00:00 CDT