Should/Can I shrink dictionary table?
Date: Wed, 15 Oct 2008 07:52:46 -0400
Implemented new packaged application on 10.2.0.3 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.