AWR automatic or manual snapshot hangs – EXADATA

Custer database manual or auto snapshot hangs and never returns:

Bug info:

https://support.oracle.com/CSP/ui/flash.html#tab=KBHome%28page=KBHome&id=%28%29%29,%28page=KBNavigator&id=%28bmDocType=BUG&bmDocTitle=AWR%20SNAPSHOTS%20HANGING&from=BOOKMARK&bmDocDsrc=BUG&bmDocID=13372759&viewingMode=1143%29%29

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..

Advertisements

Author: Abdul H Khan

Trying to be cloudy!

One thought on “AWR automatic or manual snapshot hangs – EXADATA”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s