Re: Should/Can I shrink dictionary table?

From: Jared Still <jkstill_at_gmail.com>
Date: Wed, 15 Oct 2008 09:00:10 -0700
Message-ID: <bf46380810150900q9641c23n406985c8ced0d3f0@mail.gmail.com>


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-l
Received on Wed Oct 15 2008 - 11:00:10 CDT

Original text of this message