比较简单的方式就是在Toad 9.6 版本中 database --> Diagnos --> 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
~ 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
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/35489/viewspace-625154/ ，如需转载，请注明出处，否则将追究法律责任。
