Should/Can I shrink dictionary table?

  • From: Mayen.Shah@xxxxxxxxxx
  • To: oracle-l@xxxxxxxxxxxxx, oracle-l-bounce@xxxxxxxxxxxxx
  • Date: Wed, 15 Oct 2008 07:52:46 -0400

Hi Gurus,

Implemented new packaged application on EE on Solaris9

Application server need to be recycle every week. Each time app server is 
recycled; it created many views and supposed to drop at time of shutting 
down app. Creating new views part worked fine but dropping part did not 
work. So ended up with 35829 views in one schema and sys.view$ grew to be 
600M. I caught this and after confirming with vendor, dropped all views. 

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.

Thank you for your comments.


Other related posts: