1

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?

  • 1
    I 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
2

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.

| improve this answer | |
0

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

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.