Performance & Tuning



Automatic Maintaining SQL Tuning Advisor.    

Change ADDM/AWR Snapshot interval to 2 minute     
http://dbaocm.blogspot.com/2015/03/change-addmawr-snapshot-interval-to-2.html

DBMS_STATS. GATHER_DICTIONARY_STATS fails with ORA-20001 ORA-6502 ORA-6512 - Concurrent Stats (from Oracle -Mike Dietrich)https://blogs.oracle.com/UPGRADE/entry/exec_dbms_stats_gather_dictionary

resmgr:cpu quantum


No comments:

Post a Comment