Sysaux tablespace is not extending
** Oracle is currently working on an SR on this topic, while we are diagnosing the problem we are opening up this question to our user community so they can add perspective to the solution based on their real world experience **
Problem : Sysaux tablespace is not extending
Database: 10.2.0.4
OS : Oracle Solaris on SPARC (64-bit)
Description :
SQL> select * from dba_data_files where
tablespace_name='SYSAUX';
FILE_NAME
--------------------------------------------------------------------------------
FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS
---------- ------------------------------ ---------- ---------- ---------
RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
------------ --- ---------- ---------- ------------ ---------- -----------
ONLINE_
-------
+HLR_DATA/fsv/datafile/sysaux.262.699645257
FILE_NAME
--------------------------------------------------------------------------------
FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS
---------- ------------------------------ ---------- ---------- ---------
RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
------------ --- ---------- ---------- ------------ ---------- -----------
ONLINE_
-------
+HLR_DATA/fsv/datafile/sysaux.262.699645257
0