Re: Is this Needed?
- From: "Joel Garry" <joelgarry@xxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 27 Oct 2005 17:24:45 -0700
Two things I haven't seen mentioned which might impact whether it is
needed:
1. 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.
2. 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
