unable to extend table SYS.AUD$ by 1024 in tablespace SYSTEM

登录Oracle数据库报错：ORA-01653:unable to extend table SYS.AUD$ by 1024 in tablespace SYSTEM 表空间暴满：SELECT total.tablespace_name, Round(total.MB, 2) AS Total_MB, Round(total.MB - free.MB, 2) AS Used_MB, Round(( 1 - free.MB / total.MB ) * 100, 2) || '%' AS Used_Pct FROM (SELECT tablespace_name, Sum(bytes) / 1024 / 1024 AS MB FROM dba_free_space GROUP BY tablespace_name) free,       (SELECT tablespace_name, Sum(bytes) / 1024 / 1024 AS MB FROM dba_data_files GROUP BY tablespace_name) total WHERE free.tablespace_name = total.tablespace_name; SQL> show parameter audit; NAME      TYPE VALUE ------------------------------------ ----------- ------------------------------ audit_file_dest      string /data/oracle/admin/orcl/adump audit_sys_operations      boolean FALSE audit_syslog_level      string audit_trail      string DB 关闭审计并清理表空间。 SQL> alter system set audit_trail = none scope=spfile; System altered. SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup; ORACLE instance started. Total System Global Area 5344731136 bytes Fixed Size     2262656 bytes Variable Size 3120564608 bytes Database Buffers 2214592512 bytes Redo Buffers     7311360 bytes Database mounted. Database opened. SQL> show parameter audit; NAME      TYPE VALUE ------------------------------------ ----------- ------------------------------ audit_file_dest      string /data/oracle/admin/orcl/adump audit_sys_operations      boolean FALSE audit_syslog_level      string audit_trail      string NONE SQL> truncate table aud$;   Table truncated. SELECT occupant_name "Item",        space_usage_kbytes / 1048576 "Space Used (GB)",        schema_name "Schema",        move_procedure "Move Procedure"   FROM v$sysaux_occupants ORDER BY 1； 应该是AWR和统计信息消耗了SYSAUX表空间。表空间位置：select * from dba_data_files; 扩大 SYSAUX表空间大小： SQL> alter  database  datafile  '/data/oracle/oradata/ORCL/sysaux01.dbf' resize 5G;   Database altered. 也可以删除消耗AWR的表。 问题解决。