Re: Should/Can I shrink dictionary table?

From: Jared Still <>
Date: Wed, 15 Oct 2008 09:00:10 -0700
Message-ID: <>

On Wed, Oct 15, 2008 at 4:52 AM, <> 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

Received on Wed Oct 15 2008 - 11:00:10 CDT

Original text of this message