Many Closed Records In V_$Ir_failure How to clear this view ?
Last updated on DECEMBER 21, 2016
Applies to:Oracle Server - Enterprise Edition - Version: 18.104.22.168
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.
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