Sapna Malik
What is Segment Advisor in Oracle?
By Sapna Malik in Databases & DBA on Apr 21 2011
  • Sapna Malik
    Apr, 2011 21

    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.

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS