Custer database manual or auto snapshot hangs and never returns:
Bug info:
Solution:
sqlplus / as sysdba
SQL> exec dbms_stats.gather_table_stats('SYS','X$KCCFN',no_invalidate=>false);
SQL> exec dbms_stats.gather_table_stats('SYS','X$KCCFE',no_invalidate=>false);
SQL> execute dbms_workload_repository.modify_snapshot_settings (interval => 15, retention => 1576800);
SQL> EXEC DBMS_WORKLOAD_REPOSITORY.create_snapshot;
Step above should fix the issue..
本文章为转载内容，我们尊重原作者对文章享有的著作权。如有内容错误或侵权问题，欢迎原作者联系我们进行内容更正或删除文章。
