Hello,
I need to identify the fragmented space of a table including its lob segment.
Below query gives me the fragmented size of the table without LOB
select owner,table_name,blocks,num_rows,avg_row_len,round(((blocks*8/1024)),2)||'MB' "TOTAL_SIZE",
round((num_rows*avg_row_len/1024/1024),2)||'Mb' "ACTUAL_SIZE",
round(((blocks*8/1024)-(num_rows*avg_row_len/1024/1024)),2) ||'MB' "FRAGMENTED_SPACE"
from dba_tables
where owner='USR';
How can i find the actual fragmented space of a table (with CLOB)?