Sep 17, 2009

Recreate AWR Tables in 10g

If any issue with the AWR tables we can recreate them using the below steps.
 1. Disable AWR statistics by setting the statistics level to basic, e.g.: 
  • sqlplus / as sysdba
  • show parameter statistics_level 
  • alter system set statistics_level = basic scope=both; 
2. Stop and restart the instance in restricted mode, e.g.: 
  • sqlplus / as sysdba
  • shutdown immediate 
  • startup restrict 
3. Drop and recreate the AWR objects, e.g.: 
  • sqlplus / as sysdba
  • @?/rdbms/admin/catnoawr.sql 
  • alter system flush shared_pool; 
  • @?/rdbms/admin/catsvrm.sql 
  • @?/rdbms/admin/utlrp.sql 
4. Then re-enable the AWR statistics gathering as required, by setting          
    STATISTICS_LEVEL back to its original value, and restart the instance 
    normally, e.g.: 
  • sqlplus / as sysdba
  • alter system set statistics_level = scope=both; 
  • shutdown immediate 
  • startup 

No comments:

Post a Comment

Search This Blog