Two things I haven't seen mentioned which might impact whether it is
needed:
- Are the tablespaces Dictionary managed (not the default, but can
happen with migrations or intended foolishness)? Might mean your SYSTEM
TS has too much in the way of FET$ segments, if you've had lots of
extents. Reorganizing the data TS could potentially only partially
solve the problem. Or, it could solve it in a way that would be better
solved by just converting to LMT.
- Some bad programming like creating and deleting lots of objects on
the fly - won't get helped by reorganization, but might look like it
will because SMON has been going nutso. See the last bit of
http://groups.google.com/group/comp.databases.oracle.server/msg/adb5814c
9f6b8af0?dmode=source&hl=en for an example.
Joel Garry
http://www.garry.to
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Oct 27 2005 - 19:27:25 CDT