EXP_HEAD$ is the largest consumer of SYSAUX?
In investigating the size of our SYSAUX tablespace, according to awrinfo EXP_HEAD$ is the largest consumer of the tablespace (~151GB).
There doesn't appear to be much on MOS regarding this object. I did review Bug 29240759 - MMON OPTIMIZER WORKLOAD CLEANUP ACTION IS NOT FINISHED. (Doc ID 29240759.8) which was supposed fixed as of 19.6 (this database is 19.23)
If I check the query in the MOS note, the query (which I interpret as should be purged) criteria match more than 99% of the rows in the table
1 select count()
2 from
3 exp_head$ e
4 where ((select max(nvl(es.last_modified, es.ctime))
5 from