Sysaux tablespace is growing to much and there is problem in retention purging of AWR tables then the ideal way for quick release of space is to drop and recreate the AWR repository.
++ Drop and re-install AWR
sqlplus /nolog
connect / as sysdba
@?/rdbms/admin/catnoawr
@?/rdbms/admin/catawrtb
startup force
exec dbms_workload_repository.create_snapshot;
wait for 5 min
exec dbms_workload_repository.create_snapshot;
Ref:
How to Recreate The AWR ( AUTOMATIC WORKLOAD ) Repository ? (Doc ID 782974.1)
++ Drop and re-install AWR
sqlplus /nolog
connect / as sysdba
@?/rdbms/admin/catnoawr
@?/rdbms/admin/catawrtb
startup force
exec dbms_workload_repository.create_snapshot;
wait for 5 min
exec dbms_workload_repository.create_snapshot;
Ref:
How to Recreate The AWR ( AUTOMATIC WORKLOAD ) Repository ? (Doc ID 782974.1)
No comments:
Post a Comment