RE: Should/Can I shrink dictionary table?
Date: Wed, 15 Oct 2008 11:12:33 -0500
As far as I recall, Oracle does not support automatic segment space management for the SYSTEM tablespace, with that in mind, using alter table shrink space compact and shrink space cannot be done (as it requires row movement which in turn requires ASSM). Open an SR and request for support on optimizing this particular table, but I think it cannot be done. Do you create/drop views frequently?
HTH Guillermo Alan Bort
DBA / DBA Main Team
EDS, an HP company
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jared Still Sent: Wednesday, October 15, 2008 1:00 PM To: Mayen.Shah_at_lazard.com
Cc: oracle-l_at_freelists.org; oracle-l-bounce_at_freelists.org Subject: Re: Should/Can I shrink dictionary table?
On Wed, Oct 15, 2008 at 4:52 AM, <Mayen.Shah_at_lazard.com> wrote:
I am little concerned of oversized sys.view$ table and potential performance impact, since application relies heavily on views and sys.view$ may be accessed heavily by recursive sql. How can I reclaim (shrink) space from sys.view$? sys.view$ does have long column.
Create an SR and ask support if and how you can do it.
That way you will have a supported solution.
-- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- http://www.freelists.org/webpage/oracle-lReceived on Wed Oct 15 2008 - 11:12:33 CDT