When running select from V$RMAN_STATUS output very slow in Oracle Database

When running select  from V$RMAN_STATUS output very slow in Oracle Database

While running Queries on V$RMAN_STATUS it is performing very poorly

Workaround fix:

sqlplus '/as sysdba'

exec dbms_stats.DELETE_TABLE_STATS('SYS','X$KCCRSR');

exec dbms_stats.LOCK_TABLE_STATS('SYS','X$KCCRSR');

Now Run queries on V$RMAN_STATUS . The performance will resume to normal.

If you like please follow and comment