RE: Is this Needed?
- From: "Freeman, Donald" <dofreeman@xxxxxxxxxxx>
- To: <joelgarry@xxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 28 Oct 2005 09:02:35 -0400
Nope, all the tablespaces are locally managed and the environment is stable.
Don Freeman
Database Administrator 1
Bureau of Information Technology
Pennsylvania Department of Health
717-783-8095 Ext 337
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Joel Garry
Sent: Thursday, October 27, 2005 8:25 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: Is this Needed?
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
