My Oracle Support Banner

Many Closed Records In V_$Ir_failure How to clear this view ? (Doc ID 1284123.1)

Last updated on DECEMBER 21, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: and later   [Release: 11.1 and later ]
Information in this document applies to any platform.


How to cleanup CLOSED entries in V_$IR_FAILURE after resolving the root-cause of the issues.

Symptoms :
- 121.000 records in v_$ir_failure with status CLOSED.
- Rman list failures is very slow.

SQL> select * from v$database_block_corruption;

no rows selected

But how can we get rid of the historical entries.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.