I recently got an Ora-1688 alert and realized my SYSAUX is 99.7% full. Is this a critical issue that has to be dealt with immediately? Will this cause my system to stop?
-
1I would check out dba.stackexchange.com/questions/33645/sysaux-tablespace-is-98 for some more info – Joe W Apr 8 '19 at 14:44
-
Thanks Joe for the comment! I kinda understand how to deal with it now from reading different posts etc. However would you happen to know if this issue has to be dealt with asap or could it wait(until tmrw etc). – user176695 Apr 8 '19 at 14:50
-
I am not sure what would happen if it fills up so can't say for sure but guessing it won't be good – Joe W Apr 8 '19 at 15:17
-
just extend the tablespace with a new datafile – kevinsky Apr 8 '19 at 16:49
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. Your database will not crash but only SYS db user will be able to log in - the first thing you should do in this case is to extend the SYSAUX tablespace (add a data file) and deal later with how SYSAUX got full at the first place.
Please refer the below link to know more about SYSTEM and SYSAUX tablespaces
Lack of space in SYSTEM and SYSAUX tablespace in oracle 11g R2
Thanks
answered Apr 16 '19 at 7:21
