Re: V$WAITSTAT, FREELISTS and BUFFER BUSY WAITS

Did you happen to run the following query to see if you had freelist contention?

    select class,count from v$waitstat where class='free list'

I have a high data block count and I ran the above query and the result came back with 0.

Do you know if the free list waits are only for tables?

Thanks,

K.Anderson

P.Merks wrote in message <01bd8024$9874a080$c11ebeb4_at_ispmer.northwest.ca>...
>I have a 'couple' of oracle databases that are reporting very high buffer
>busy waits and when I select from v$waitstat I get (what I think) are very
>high numbers for data_block indicating block contention.
>
>On one of the databases, knowing the application it was very obvious which
>table was the source of the contention ie which table had the most
>simultaneous updates and inserts of data. For this I was able to increase
>the freelists just for the indexes and this alone has made a HUGE
>difference for some jobs. For the other database I have no idea which
>tables or index blocks are experiencing the most contention.
>
>My question: How can I correlate high values for data_block in v$waitstat
>or high buffer busy waits to a specific object. The documenation I have
>seen refers me to v$session_wait but I don't see an obvious correlation.
>
>thanks,
>
>P. Merks
>Winnipeg, Manitoba
>Canada
Received on Wed May 20 1998 - 00:00:00 CEST