SQL> exec dbms_stats.DELETE_TABLE_STATS(‘SYS’,’X$KCCRSR’)
SQL> select p, NULL, NULL from (select count(*) p from v$rman_status where operation = ‘BACKUP COPYROLLFORWARD’);
Advertisements
SQL> exec dbms_stats.DELETE_TABLE_STATS(‘SYS’,’X$KCCRSR’)
SQL> select p, NULL, NULL from (select count(*) p from v$rman_status where operation = ‘BACKUP COPYROLLFORWARD’);
I was having the issue . any query on v$rman_status going to controlfile sequential read wait event and never returning the results. The above fix worked for me in 12.1.0.1 database