Database Administration (MOSC)

MOSC Banner

EXP_HEAD$ is the largest consumer of SYSAUX?

edited Jul 17, 2024 5:33PM in Database Administration (MOSC) 4 commentsAnswered

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

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