Overview

Your tablespace report has started to report an issue with the SYSAUX tablespace.

Example:

Tablespace: SYSAUX
-------------------------------------------------------
Max. Size (M) : 2500
Current Size (M) : 2500
Current Free (M) : 276
Fragment count : 39
Percent Free Space : 11.05%
WARNING: Free space below 20 percent or 10 Mb, tablespace extension required.
-------------------------------------------------------

Solution

SYSAUX is a system Oracle tablespace. The maximum size for the tablespace should be increased to 3000MB to make the available space to be more than 20%.

Please contact Customer Support asking to extend the max size of the SYSAUX tablespace.

<supportagent>

This solution requires access to the database.

Use the following query to extend the maximum size of the SYSAUX tablespace to 3000MB:

alter database datafile '/data1/oradata/T/dbsT.sa1' autoextend on MAXSIZE 3000M;

</supportagent>