12 Sep
10G Shrink Command
We were in the process of discussing 10G Grid Control’s Segment Analyzer before being interrupted by a one terabyte table that I discussed in the last blog. In this blog, I’ll get back on track by reviewing the different alternatives we can use to reclaim wasted space in Oracle10G.
Since the Segment Analyzer and online shrink command were introduced in Oracle10G, I’ll spend a few minutes discussing how you can identify and shrink objects in pre-10G releases.