Tablespace Fragmentation - 表空間碎片問題

比較簡單的方式就是在Toad 9.6 版本中  database --&gt Diagnos --&gt Health Check .  

Tablespace Fragmentation

~ A common set of extent sizes is a good way to reduce tablespace fragmentation.
~ Sometimes fragmentation can be improved with 'Alter tablespace coalesce'.
~ Tablespace fragmentation should not be a problem if you use locally managed tablespaces. 

本地管理的表空間碎片應該不是問題 。

======================================================================
== TableSpace Name                     %         # of        # of   ==
==                                 Fragmented    Extents     Holes  ==
======================================================================
! WEBMINDX_LGA                        69            101      227
! WEBMDATA_LGA                        38            227      138
! WMB2B6                              80             81      319