Àˬdtablespace¯}¸HªÅ¶¡

vean0803i

select tablespace_name ,
   sqrt(MAX(blocks)/SUM(blocks))*(100/sqrt(sqrt(count(blocks)))) as "FSFI%"
from dba_free_space
group by tablespace_name
order by 1;

      tablespace:ªí®æªÅ¶¡¦WºÙ

FSFI:¥i¥Î¯}¸HªÅ¶¡¯Á¤Þ(Free Space Fragmention Index)¡A¼Æ­È³Ì¤j100¡Aªí¥Ü§¹¥þ¨S¦³¯}¸HªÅ¶¡¡A¼Æ­È¶V§C¥NªíªÅ¶¡ªº¸H¤ù¶VÄY­«¡A³q±`§C©ó30%´N»Ý­n¶i¦æ­«¾ã§@·~(Recorganization Job)¡A³o¬O¸ê®Æ®wºÞ²z­û¬O«D±`­«­nªº¨Ò¦æ§@·~¡C


­º¥ý­×¥¿SYSAUX
COALESCE

For each datafile in the tablespace, this clause combines all contiguous free extents into larger contiguous extents. Please use Locally managed tablespace, it will automatically take care of this issue.

DEALLOCATE UNUSED
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14200/clauses003.htm#g1056929



10G·s¥\¯à


alter table mytable enable row movement;

alter table xxx shrink space compact