Re: Should/Can I shrink dictionary table?
- From: "Jared Still" <jkstill@xxxxxxxxx>
- To: Mayen.Shah@xxxxxxxxxx
- Date: Wed, 15 Oct 2008 09:00:10 -0700
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:
