1:查看是否开启AUDIT审计功能
有值,开启
2:查看AUD$大小
select *
from (select SEGMENT_NAME, sum(bytes) / 1024 / 1024 v_size
from dba_segments
where tablespace_name = 'SYSTEM'
group by segment_name)
where v_size > 100
order by v_size desc;
---sys下查询
select count(*) from aud$;
3:清空aud$--sys账号执行
truncate table aud$;
4:关闭aud$
alter system set audit_trail=none scope=spfile;
重启数据库
注:设置自动扩展,或则增大表空间,或则清空aud$