Re: Should/Can I shrink dictionary table?
Date: Wed, 15 Oct 2008 09:00:10 -0700
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:00:10 CDT