Re: Help with interpreting TKPROF output

On 29 Aug 2003 12:53:17 -0700, yong321_at_yahoo.com (Yong Huang) wrote:

>I won't conclude but I think the buffer reads ("query" and "current"
>columns) use the unit of number of buffers, not number of times of
>reading buffers.

This is not true. The buffer reads show the number of reads not the number of buffers consumed. You could easily verify this using the v$bh view.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sun Aug 31 2003 - 05:21:45 CDT