Which two categories of segments are analyzed by the Automatic Segment Advisor?
A.
segments in tablespaces that have exceeded a critical or warning space threshold
B.
segments that have the highest growth rate in a database
C.
segments that are sparsely populated and have more than 10% of free space below the high water mark.
D.
segments that have unusable indexes
E.
segments for tables created using ADVANCED ROW COMPRESSION
Explanation:
http://www.dba-oracle.com/t_segment_advisor_10g.htm