版本:
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