Re: Long time for v$database_block_corruption to return

From: hpuxrac <>
Date: Thu, 27 Nov 2008 14:40:13 -0800 (PST)
Message-ID: <>

On Nov 27, 12:33 pm, 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

Original text of this message