KB : How to check database table fragmentation
1) Rule of thumb to perform de-fragmentation for Database table which are greater than 80%. 2) Example of the output of Database: - OWNER TABLE_NAME TABLESPACE_NAME TOTAL_SIZE_MB ACTUAL_SIZE_MB FRAGMENTED_SPACE_MB ------------ --------------------- ...