Verifique Fragmentação de objetos do seu Schema

Nota: quantos mais extents, maior será a fragmentação

col MAX_EXTENTS format 999999999999
break on OWNER;

select substr(owner,1,15), substr(SEGMENT_NAME, 1,30), substr(SEGMENT_TYPE,1,10),
substr(TABLESPACE_NAME,1,20), EXTENTS, MAX_EXTENTS
from dba_segments
where owner like ('P%')
order by owner, extents desc;