Re: high data block waits in v$waitstat 8.1.7

well in v$waitstat it is supposed to be data block waits no? buffer waits is in v$system_event?
buffer waits is low, but data block waits are high

I see high waits in v$waitstat that's why I think there is a problem, I can get statspack report since I have it scheduled hourly. Which part would you like to see since as it's pretty big.....

Ricky Sanchez wrote:

> Your original message says you are seeing high "data block" waits. What
> exactly do you mean? Buffer busy wait, of "data block" type? How does
> the buffer busy wait event compare to other wait events?
>
> You say v$system_event is "healthy". What exactly are you seeing that
> makes you think you have a problem? Is this a sudden onset problem or
> something chronic with this instance? When was performance good? What
> were the top wait events then?
>
> How about at least a clip of a statspack report to give us some clues?
>
> - ricky
>
> sg wrote:
>

>>Actually my v$sysstat and v$system_event are all pretty healthy but then
>>what could be the cause of high data block waits?
>>
>>Most waits in v$system_event are I/O and sqlnet messages
>>
>>