TO Check The Frag % On tables........

select a.owner,a.table_name,round(b.bytes/1024/1024) "currentsize in MB",round((a.num_rows*a.avg_row_len)/1024/1024) "actualsize in MB",round(((b.bytes/1024/1024-((a.num_rows*a.avg_row_len)/1024/1024))/(b.bytes/1024/1024))*(100-a.pct_free),2) "frag percent" from dba_segments b,dba_tables a where a.owner=b.owner
and b.bytes/1024/1024>100 and b.segment_name=a.table_name and a.owner='DSI_DPIPE';