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: 126.96.36.199
Information in this document applies to any platform.
- 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!