Re: Freelists and Freelist Groups

Jonathan Lewis a écrit :
> The time lost on buffer busy waits is a small fraction
> of the time lost on physical I/O; moreover, one of
> the causes of buffer busy waits is excessive I/O.
> Consequently, you should be addressing the I/O
> problem first, as a reduction in I/O may result in
> the elimination of the buffer busy waits.
>
> Check v$sql for any queries where disk_reads is high,
> especially if it is also a significant fraction of the buffer_gets,
> and see if you can find ways to make them more efficient.
>
>

Thanks for all the answers. I'll look after v$sql to find out which queries and which tables/indexes cause the most trouble and try to make it work efficiently.

Emmanuel Received on Mon Nov 21 2005 - 02:29:37 CST