Database Administration (MOSC)

MOSC Banner

how to drop/recreate awr repository to reclaim SYSAUX space in 11g

edited Dec 15, 2020 5:31PM in Database Administration (MOSC) 4 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center