set lines
300 pages 300 ;
select
a.owner, a.table_name, b.bytes/1024/1024/1024 "Size(GB)", (a.avg_row_len*a.num_rows/1024/1024/1024)
"Actual(GB)",
to_char(last_analyzed,'DD-MON-YY')
"LAST ANAL",
trunc((b.bytes/1024/1024/1024)
- (a.avg_row_len*a.num_rows/1024/1024/1024)) "Diff(GB)" ,
(b.bytes-a.avg_row_len*a.num_rows)*100/
b.bytes "% Frag"
from
dba_tables a,
dba_segments
b
where
a.table_name = b.segment_name
and a.owner
= b.owner
and a.table_name ='table_name'
order by 6
