Oracle DB级别审计日志查看及清理

一、查看审计日志大小

SELECT segment_name, round( sum( bytes / 1024 / 1024 / 1024 ), 2 ) gb FROM dba_segments WHERE segment_type = 'TABLE' and segment_name = 'AUD$' group by segment_name;

二、清理审计日志

truncate table AUD$;