29 Aug
10G Segment Advisor
The 10G segment advisor identifies segments that have become fragmented as a result of update and delete operations. Oracle describes these objects as being sparsely populated. Not only do sparsely populated objects waste space but they can also contribute to SQL performance problems.
This blog will show you how to use the 10G segment advisor to identify sparsely populated segments. In my next blog, we’ll discuss the different alternatives we can use to reclaim the wasted space.