AWR taking up most of the space in sysaux
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