Is it possible to predict the space that will be freed before actually shrinking the segment?
Which dict view or dynamic performance could be used for this?
Yes.
Segment Advisor utility tells current allocated space, how much space is "actually" in use and how much space will be reclaimed if segment gets shrink.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Yes.
Segment Advisor utility tells current allocated space, how much space is "actually" in use and how much space will be reclaimed if segment gets shrink.
Hmm.If so, then it must be picking this information from some dict table or dynamic performance view.
Actually, the customer is using Solaris setup and we access DB using telnet. He is of the opinion that everything could be done using telnet.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Reply With Quote
Originally Posted by PAVB
Bookmarks