Verifica Status SYS.AUD$

set verify off;
set lines 1000;
set pages 300;
column value new_val blksize;
select value from v$parameter where name = 'db_block_size';
select a.file_id,
a.file_name,
ceil((nvl(hwm,1)*&&blksize)/1024) smallest,
ceil(blocks*&&blksize/1024) currsize,
ceil(blocks*&&blksize/1024) -
ceil((nvl(hwm,1)*&&blksize)/1024) savings
from dba_data_files a,
(select file_id, max(block_id+blocks-1) hwm
from dba_extents where owner='SYS'
group by file_id) b
where a.file_id = b.file_id;




analyze table sys.AUD$ compute statistics;

select
a.blocks, b.blocks hwm, b.empty_blocks
from
dba_segments a, dba_tables b
where
a.SEGMENT_NAME = 'AUD$' and b.TABLE_NAME='AUD$';