v$rman_status查询缓慢

版本：
        Oracle 11.2.0.4

现象：
        v$rman_status查询缓慢(几分钟都查不出结果)，session中event显示为control file sequential read，查看执行计划，执行计划中有 "MERGE JOIN CARTESIAN"

解决办法：
        exec dbms_stats.DELETE_TABLE_STATS('SYS','X$KCCRSR')；
        exec dbms_stats.LOCK_TABLE_STATS('SYS','X$KCCRSR');

 

参考：
        Bug 14078947 - Select from V$RMAN_STATUS very slow when database is open (Doc ID 14078947.8)

        If a select from v$rman_status is slow then this may be the same bug, especially if the execution plan shows "MERGE JOIN CARTESIAN" operations