Oracle 11g SYSTEM tablespace explosion problem
Oracle 11g SYSTEM tablespace explosion problem
I. View the top 9 segments of the SYSTEM tablespace
SQL > set lines 120
SQL > col owner for A30
SQL > col segment_name for A30
SQL > col owner for A30
SQL > SELECT
2 FROM (SELECT BYTES, segment_name, segment_type, owner
3 FROM dba_segments
4 WHERE tablespace_name = 'SYSTEM'
5 ORDER BY BYTES DESC)
6 WHERE ROWNUM
< 10; BYTES SEGMENT_NAME SEGMENT_TYPE OWNER 8053063680 AUD$ TABLE SYS 285212672 C_OBJ#_INTCOL# CLUSTER SYS 285212672 IDL_UB1$ TABLE SYS 75497472 SOURCE$ TABLE SYS 49283072 I_H_OBJ#_COL# INDEX SYS 47185920 HIST_HEAD$ TABLE SYS 33554432 IDL_UB2$ TABLE SYS 27262976 I_HH_OBJ#_COL# INDEX SYS 26214400 I_HH_OBJ#_INTCOL# INDEX SYS 9 rows selected. 二、原因 数据库开启了审计，可以通过参数查看。 SQL>Show parameter audit_trail
NAME TYPE VALUE
Audit_trail string DB
SQL >
III. Solutions
1. Clean up the aud$ segment
Truncate table aud$
2. Further, you can close the audit. By modifying audit_trail=none, you need to restart the database.
