登录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的表。

问题解决。