Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
What is the SYSAUX Tablespace and What is it used for?
In Oracle databases, SYSAUX tablespace is an auxiliary storage space for SYSTEM tablespace. Most Oracle database components that are not critical for basic functionality are stored in the SYSAUX tablespace. If the SYSAUX table space becomes unavailable, the database will still run, but database components that use SYSAUX components will become inoperable or have limited features.
Find SYSAUX Tablespace Usage
How much SYSAUX tablespace is used by which component in Oracle databases can be accessed from the V$SYSAUX_OCCUPANTS view.
Since the records of the audit operations are stored in the SYSAUX tablespace, the SYSAUX tablespace can be full when there are too many records, so the space used in the SYSUX tablespace for the audit should be checked from time to time. You can use a query like the following for this check.
1 2 3 4 5 6 | SQL> select occupant_name,schema_name,occupant_desc,space_usage_kbytes from v$sysaux_occupants where occupant_name like 'AUD%'; OCCUPANT_NAME SCHEMA_NAME OCCUPANT_DESC SPACE_USAGE_KBYTES ------------------- ------------------- --------------------------- ------------------ AUDSYS AUDSYS AUDSYS schema objects 10368 AUDIT_TABLES SYS DB audit tables 0 |
