Shulou(Shulou.com)06/01 Report--

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.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.