Hi Tom,
I’m encountering an issue with my Oracle Database 23Free. It throws the ORA-12954 error: "The request exceeds the maximum allowed database size of 12 GB." After investigating the database files, I discovered that the SYSAUX tablespace is the main contributor to the size issue.

/opt/oracle/oradata/FREE/FREEPDB1/sysaux01.dbf       6.1GB
/opt/oracle/oradata/FREE/FREEPDB1/system01.dbf       0.6GB
/opt/oracle/oradata/FREE/FREEPDB1/undotbs01.dbf       0.3GB
/opt/oracle/oradata/FREE/FREEPDB1/users01.dbf       0.3GB
/opt/oracle/oradata/FREE/pdbseed/sysaux01.dbf       0.3GB
/opt/oracle/oradata/FREE/pdbseed/system01.dbf       0.3GB
/opt/oracle/oradata/FREE/pdbseed/undotbs01.dbf       0.1GB
/opt/oracle/oradata/FREE/sysaux01.dbf               6.6GB
/opt/oracle/oradata/FREE/system01.dbf               1.2GB
/opt/oracle/oradata/FREE/undotbs01.dbf               0.6GB
/opt/oracle/oradata/FREE/users01.dbf               0.0GB

Upon further examination using

select * from V$SYSAUX_OCCUPANTS;

it seems that the majority of the space is being utilized by:
• SM/AWR
• SM/OPTSTAT

To address this, I attempted to purge statistics using the following PL/SQL block:

BEGIN
   dbms_stats.purge_stats(dbms_stats.purge_all);
END;

However, I received the ORA-12954 error again during this process.

Do you have any advice on how to resolve this issue and bring the database back within the size limit? Your help would be greatly appreciated!
Best regards,
Christian