There is also freespace fragmentation.
Check dba_free_space for amount of entries of freespace.
select tablespace_name, max(bytes/1024/1024), min(bytes/1024/1024), count(*)
from dba_free_space
group by tablespace_name;
check count(*) column, if more than 1000, possible fragmentation.
If you move to LMT, there is no need to worry about fragmentation.




Reply With Quote