What happens if Sysaux tablespace is full?

If your Database has enabled AUDIT and your auditing tablespace SYSAUX gets 100% full, NONE of database users will be able to log in to database anymore.

How do I free up space on Sysaux tablespace?

SYSAUX Before Cleanup:

1. Check whats occupying SYSAUX tablespace: Run below query to know what all occupants are there in sysaux occupying all the space.
2. Check AWR Retention Period: First is to check what is the AWR retention period in DB.
3. Cleanup old AWR reports to free up space:

Can we increase Sysaux tablespace?

To alter the SYSAUX tablespace, you must have the SYSDBA system privilege. If you have ALTER TABLESPACE system privilege, then you can perform any ALTER TABLESPACE operation.

What is Sysaux used for?

The SYSAUX tablespace provides storage of non-sys-related tables and indexes that traditionally were placed in the SYSTEM tablespace. For example, the tables and indexes that were previously owned by the system user can now be specified for a SYSAUX tablespace.

What do you need to know about SYSAUX tablespace?

With the new SYSAUX tablespace, Oracle comes closer to providing all the needed tablespaces for a truly OFA-compliant database right out of the box. With just one CREATE DATABASE command we can specify the SYSTEM tablespace, the TEMPORARY tablespace, the SYSAUX tablespace, the default UNDO tablespace, and the redo logs.

Why is my SYSAUX table so big in Oracle?

Recently in one of our Oracle instances sysaux tablespace grew huge and filled up the complete tablespace. We were also not able to resize the tablespace to create some free space.

Where are indexes and tables stored in SYSAUX?

SYSAUX tablespace The SYSAUX tablespace provides storage of non-sys-related tables and indexes that traditionally were placed in the SYSTEM tablespace. For example, the tables and indexes that were

How to create some free space in SYSAUX?

So here in this article we will discuss on how to create some free space in SYSAUX to continue normal database operations but before going into details we shall know few basics about SYSAUX to help understand the process better. In Oracle SYSAUX tablespace is considered as an auxiliary tablespace to the SYSTEM tablespace.