Database Administration (MOSC)

MOSC Banner

Oracle database complains about Unable to extend SYSAUX tablespace, despite it being 15% full

edited May 31, 2024 7:02PM in Database Administration (MOSC) 8 commentsAnswered ✓

hi,

Anyone know why I would be getting these errors?

OT1QA91P(3):Unified Audit record write to audit trail table failed due to ORA-30032. Writing the record to OS spillover file.
OT1QA91P(3): ORA-01688: unable to extend table AUDSYS.AUD$UNIFIED partition SYS_P28100 by 1024 in tablespace SYSAUX

I have Oracle 19c, 19.4.0.0. RAC database on Oracle Linux 7.9

I used below query to confirm my SYSAUX is 15% full only.

set linesize 1000
select a.tablespace_name,
a.bytes_alloc/(1024*1024) "TOTAL ALLOC (MB)",
a.physical_bytes/(1024*1024) "TOTAL PHYS ALLOC (MB)",
nvl(b.tot_used,0)/(1024*1024) "USED (MB)",
(nvl(b.tot_used,0)/a.bytes_alloc)*100 "% USED"

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center