How to truncate audit tablespace ?
select sum(bytes)/(1024*1024) "Table size(MB)" from dba_segments where segment_name='AUD$' and owner='SYS';
select count(*) from sys.aud$;
select owner,segment_name,segment_type,tablespace_name,bytes/1024/1024 "MB Size" from dba_segments where segment_name='AUD$';
TRUNCATE table sys.AUD$;
select count(*) from sys.aud$;
No comments:
Post a Comment