Re: Long time for v$database_block_corruption to return
Date: Fri, 28 Nov 2008 10:55:36 -0800 (PST)
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
> 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