Oracle 11g SYSTEM表空间快速增长问题解决 一、.查看SYSTEM表空间前9大的段 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_t
Oracle 11g SYSTEM表空间快速增长问题解决
一、.查看SYSTEM表空间前9大的段SQL> set lines 120SQL> col owner for a30SQL> col segment_name for a30SQL> col owner for a30SQL> 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 SYS285212672 C_OBJ#_INTCOL# CLUSTER SYS285212672 IDL_UB1$ TABLE SYS75497472 SOURCE$ TABLE SYS49283072 I_H_OBJ#_COL# INDEX SYS47185920 HIST_HEAD$ TABLE SYS33554432 IDL_UB2$ TABLE SYS27262976 I_HH_OBJ#_COL# INDEX SYS26214400 I_HH_OBJ#_INTCOL# INDEX SYS
9 rows selected.
二、原因数据库开启了审计，可以通过参数查看。SQL> show parameter audit_trail;
NAME TYPE VALUE
audit_trail string DBSQL>
三、解决方法1、清理aud$段truncate table aud$;2、进一步可以关闭审计，通过修改audit_trail=none，需要重启数据库
更多Oracle相关信息见Oracle 专题页面 https://www.558idc.com/topicnews.aspx?tid=12
