RE: Should/Can I shrink dictionary table?
- From: "Bort, Guillermo" <guillermo.bort@xxxxxxx>
- To: <jkstill@xxxxxxxxx>, <Mayen.Shah@xxxxxxxxxx>
- 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
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jared Still
Sent: Wednesday, October 15, 2008 1:00 PM
To: Mayen.Shah@xxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx; oracle-l-bounce@xxxxxxxxxxxxx
Subject: Re: Should/Can I shrink dictionary table?
On Wed, Oct 15, 2008 at 4:52 AM, <Mayen.Shah@xxxxxxxxxx> 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
Other related posts:
