The segment advisor provides advice on whether an object is a good candidate
for a shrink operation based on the level of space fragmentation within that
object. The advisor also reports on the historical growth trend of segments. We
can use this information for capacity planning and for arriving at an informed
decision about which segments to shrink.