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: 11.1.0.7 and later   [Release: 11.1 and later ]
Information in this document applies to any platform.

Goal

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.

Solution

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 hundreds of Community platforms