1
Reply

What is Segment Advisor in Oracle?

Sapna Malik

Sapna Malik

13y
4.1k
0
Reply

    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.