17_Fragmentation.txt

17_Fragmentation.txt

set feedback off
col ALOCADO_MB format 9999999.99
col ALOCADO_MB format 9999999.99
col FRAG_MB format 9999999.99

select table_name, last_analyzed, round((blocks*8),0)/1024 ALOCADO_MB, round((num_rows*avg_row_len/1024),0)/1024 UTILIZADO_MB,
round((blocks*8),0)/1024 - round((num_rows*avg_row_len/1024),0)/1024 FRAG_MB
from dba_tables
where owner=upper('&owner')
and table_name = upper('&table')
/