ORACLE AUD$ table problem

Oracle 11g, the AUDIT function start automatically.

Therefore the table keep increasing. 

Solution

If you need the audit function, move to other tablespace;

1. move the aud$ table to other tablespace:
alter table sys.aud$ move tablespace monitor;alter table sys.aud$ move lob(sqlbind) store as( tablespace monitor);
alter table sys.aud$ move lob(SQLTEXT) store as( tablespace monitor);2. truncate the table
TRUNCATE TABLE sys.aud$;

If you need the audit function, no need to move;

1. backup the aud$ table;

2. truncate the aud$ table; 

TRUNCATE TABLE sys.aud$;

If you do not need the audit function

1. disable the audit function;

ALTER SYSTEM SET AUDIT_TRAIL=none SCOPE=SPFILE;

restart the db

2. truncate the aud$ table;

TRUNCATE TABLE sys.aud$;