Tablespace sysaux for almost of regular sizes of databases are under 2G and for some big databases they are growing a lot. We need to stay alert with, because many of bugs are related with some jobs who can’t remove some old records on tables using sysaux.

First step: run awrinfo.sql

This script will help – with a report of all detailed occupants of tablespace sysaux.

This can take a time and we have a lot of documents on MOS related with bugs who we need investigate to make sure we not hit a bug.

 @?/rdbms/admin/awrinfo.sql