Wednesday, 25 February 2015

Alter the size of SYSAUX tablespace - SYSAUX tablespace is full Oracle 11g

Scenario:


SYSAUX tablespace is full.


Version:


Oracle 11.2.0.4


OS:

Windows


Solution:


There are 2 solutions:
1. Alter/increase the size of SYSAUX tablespace
2. Cleanup SYSAUX tablespace


Example:


Here is the example to alter/increase the size of SYSAUX tablespace (with autoextend and maximum size of the file to be 8GB):
(Please note that file_id here used is 2 for SYSAUX tablespace. Please verify the file_id for SYSAUX tablespace in DBA_DATA_FILES table before running this command)

alter database datafile 2 autoextend on next 10M maxsize 8G;


Oracle documentation on Changing Datafile Size:


http://docs.oracle.com/cd/B28359_01/server.111/b28310/dfiles003.htm#ADMIN11423

No comments:

Post a Comment