Re: high data block waits in v$waitstat 8.1.7

From: sg <s4v4g3_at_europe.com>
Date: Sat, 22 Jun 2002 01:22:42 +0200
Message-ID: <3D13B542.1010000@europe.com>

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

Mark D Powell wrote:

> sg <s4v4g3_at_europe.com> wrote in message news:<3D12C3AC.3080500_at_europe.com>...
> 

>>Hii
>>
>>Does anyone know how to diagnostic data block waits in 8i? Currently we
>>see around 1000 data block waits increase per day in a 100 users Oracle
>>iAS (forms, reports and discoverer) OLTP application/system. I have
>>recently increase the freelists of all tables to 4 but it seems it has
>>no effect YET since freelists are added to new blocks only.
>>
>>I know we have to monitor v$session_wait wand watch for p1, p2 and p3
>>columns but is there another way or I have to sit there and do select *
>>from v$session_wait all the time :?
>>
>>Does this improve in 9i or we have to use same technique?
>>

> 
> SG, what made you think that free lists had anything to do with your
> data block waits?  Was the number of free list waits in v$sysstat high
> as a percentage of get IO requests?
> 
> For that matter more detail on why you think the block waits are a
> problem might help get you an on-target response to your specific
> problem.
> 
> IMHO -- Mark D Powell --
> 

Received on Fri Jun 21 2002 - 18:22:42 CDT