AWR in Exadata BP#12+

Hi Everyone,

AWR has wealth of performance related information. Apparently in Exadata x2-2 with Database Bundle Patch 12 and + broken for some reason.

Scheduled WR snapshots never completes. Manual snapshots just hangs.

We had Database Bundle patch 12 and we have noticed the issue,. Our Latest Exadata x2-2 Quarter Racks having database bundle patch 14 - with same AWR snapshot issues.
After gathering fixed object statistics, issue has gone away. :-)

SQL> EXEC dbms_workload_repository.create_snapshot;

....just hangs..

SQL> exec DBMS_STATS.GATHER_FIXED_OBJECTS_STATS;

PL/SQL procedure successfully completed.

SQL>


SQL> EXEC dbms_workload_repository.create_snapshot;

PL/SQL procedure successfully completed.

SQL>


Hope someone will benefit out there.

2 comments:

Suresh Lakshmanan said...

This was with 11.2.0.2 DB.

Suresh Lakshmanan said...

If that still doesn't work, try collecting
exec DBMS_STATS.GATHER_DICTIONARY_STATS ; then it will start working.

Suresh