how to drop/recreate awr repository to reclaim SYSAUX space in 11g
I'm working on a lab database. I want to drop the AWR repository and recreate in order to reclaim the space.
SYSAUX is 99.7% full
Oracle RAC 11g. 11.2.0.4, Linux 6.7
SQL> col OCCUPANT_NAME format a30 SELECT occupant_name, space_usage_kbytes FROM V$SYSAUX_OCCUPANTS order by 2 desc; SQL> OCCUPANT_NAME SPACE_USAGE_KBYTES ------------------------------ ------------------ SM/AWR 56092800 SM/ADVISOR 226816 XDB 128896 SM/OPTSTAT 71232 JOB_SCHEDULER 66816
Thanks
0