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?
How critical is it if SYSAUX is full
oracle
Related Question
- Oracle 11G – What Happens if SYSAUX Tablespace is Dropped
- How to reduce sysaux tablespace size with Audit Trail Unified enabled
- Oracle 11g – Incomplete SYSAUX EXPDP Unload
- Lack of Space in SYSTEM and SYSAUX Tablespace in Oracle 11g R2
- SAP Oracle Full Online Backup Failing
- Oracle 12c Outage – Investigating with SQL*Plus
- Oracle – How to Get Syntax and Logical ORA in a Trace File
- Oracle – Ramifications of Full SYSAUX Tablespace
Best Answer
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.