Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: high data block waits in v$waitstat 8.1.7
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?
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
>
Received on Sat Jun 29 2002 - 21:27:11 CDT