Re: high data block waits in v$waitstat 8.1.7

Of course. Sorry, I misread the original post. The thing about those block waits is not so much the number, but the total time. So, if you get lots of events with little or no measurable time involved, I would not worry about it. And the time is all relative to all other wait events' total time, so you need to start with the big picture. Statspack is a pretty good tool for that.

For a Statspack analysis, I would suggest starting with the top wait events, to put things into perspective. Also clip out the tablespace and file IO statistics to look for contention. If the report zips up small enough, go ahead and post the whole thing as an attachment, otherwise the clips suggested will suffice.

• ricky

sg wrote:
>
> 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.....
>
Received on Sat Jul 06 2002 - 09:56:43 CDT