Database Tuning (MOSC)

MOSC Banner

AWR taking up most of the space in sysaux

edited Mar 9, 2017 2:34PM in Database Tuning (MOSC) 10 commentsAnswered ✓

Not entirely sure where to stick this question...

I have what was supposed to be a small instance of Oracle set up to be an rman recovery catalog, that has grown hugely, far beyond what it’s was supposed to do in the Oracle documentation.

Finally found some time to go spelunking into the instance and have discovered that nearly all the space taken up by the database is the sysaux1 datafile, and looking at v$sysaux_occupants the main culprit there is the Automatic Workload Repository.

ran : (found this script here https://jhdba.wordpress.com/2009/05/19/purging-statistics-from-the-sysaux-tablespace/)

set linesize 120

set pagesize 100

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