Re: Long time for v$database_block_corruption to return
Date: Thu, 27 Nov 2008 14:40:13 -0800 (PST)
Message-ID: <b68f00b2-f564-416a-9da2-fb192c825972@v38g2000yqb.googlegroups.com>
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 ... Received on Thu Nov 27 2008 - 16:40:13 CST