Long time for v$database_block_corruption to return

From: <saturnboy_at_gmail.com>
Date: Thu, 27 Nov 2008 09:33:50 -0800 (PST)
Message-ID: <b5201b98-a27c-430b-a806-63201b553984@y18g2000yqn.googlegroups.com>


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? Received on Thu Nov 27 2008 - 11:33:50 CST

Original text of this message