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 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.
Regards
Mayen
Other related posts:
