RE: Is this Needed?

From: Freeman, Donald <dofreeman_at_state.pa.us>
Date: Fri, 28 Oct 2005 09:02:35 -0400
Message-ID: <51327ABA927BEF4B96590554CEA7832C019309B0@enhbgpri05.pa.lcl>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Joel Garry Sent: Thursday, October 27, 2005 8:25 PM To: oracle-l_at_freelists.org
Subject: Re: Is this Needed?

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

--

http://www.freelists.org/webpage/oracle-l Received on Fri Oct 28 2005 - 08:05:10 CDT