My SYSAUX tablespace is 98% full. In my tablespace statement AUTOEXTENSIBLE=yes
.
So I want to know that will it add a new data file if it reaches 100% or if not then should I make makesize to unlimited?
oracle
My SYSAUX tablespace is 98% full. In my tablespace statement AUTOEXTENSIBLE=yes
.
So I want to know that will it add a new data file if it reaches 100% or if not then should I make makesize to unlimited?
Best Answer
No, Oracle won't add an extra datafile.
Normally the SYSAUX tablespace is more or less stable so it would be smart to check what is eating the space in there. Connected as a DBA user, run the script
${ORACLE_HOME}/rdbms/admin/utlsyxsz
to get the current usage of the SYSAUX tablespace and see how it will grow when you change certain parameters for which you are asked to enter values.See Oracle® Database Administrator's Guide 11g to get an idea of regular sizing.