Re: Long time for v$database_block_corruption to return

On Nov 27, 3:40 pm, hpuxrac <johnbhur..._at_sbcglobal.net> wrote:
> On Nov 27, 12:33 pm, saturn..._at_gmail.com wrote:
>
> > Hi,
>
> > I've been noticing on Enterprise Manager that I am getting spikes in
> > activity every 20 minutes or so. It is running the query:
>
> >  "SELECT nvl(sum(blocks), 0) FROM v$database_block_corruption".
>
> > This can take up to two minutes to return, even though there are no
> > corrupt blocks. I have a duplicate machine, which returns almost
> > immediately from this query. This machine had a bad backup a while
> > ago, but it had been resolved.
>
> > Does anyone have any idea why this may take so long to to, and what I
> > can do to reset it or something.
>
> My guess is that taking another "good" rman backup should fix the
> situation.
>
> It might be interesting to put in a 10046 trace while it still has the
> problem and see what it is waiting on exactly ...

I have done backups since that have all been good. It always returns a 0.

I ran the trace and it comes up with a whole bunch of wait on control file sequential read. Received on Fri Nov 28 2008 - 12:55:36 CST