Re: Control File Sequential Read - top wait

Mladen Gogala <gogala_at_sbcglobal.net> wrote in message news:<pan.2004.07.23.03.24.05.334944_at_sbcglobal.net>...
> On Wed, 21 Jul 2004 22:47:46 +0000, Anurag Varma wrote:
...
> >
> > Just a wild guess: http://www.ixora.com.au/tips/event_10359.htm
> >
> > Anurag
>
>
> The behavior that Steve Adams is talking about is a result of an ancient
> bug (BUG# 733426). The link to the 9.0.1 manual is non-functional. I
> would contact Oracle support, rather then just setting the event 10359.

Steve's reference to the manual is moved here: http://download-west.oracle.com/docs/cd/A91202_01/901_doc/appdev.901/a88879/adl09be3.htm#121892

Table 9-1 in "LOB Performance Guidelines" no longer has the Event 10359 column in 9.2 documentation and the table is completely gone in 10g documentation.

To OP (Dusan), is there any operation with which you can reproduce heavy Control File Sequential Read wait shown in v$session_wait? If so, please tell us what p1, p2 and p3 are, whether seq# increments, and what session it is. I'm thinking that based on p2 (location inside the controlfile), we may be able to dump the controlfile and see what part of it is being read so often.

Yong Huang Received on Mon Jul 26 2004 - 11:38:47 CDT