Monday , May 20 2024

SYSAUX Tablespace Usage

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.


About dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *