You have 100 segments in the USERS tablespace. You realize that the USERS tablespace
is running low on space.
You can use Segment Advisor to _____.
A.
identify the segments that you should shrink
B.
modify the storage parameters for the tablespace
C.
automatically shrink the segments with unused space
D.
check the alerts generated for the tablespace that is running low on space
A is correct:
http://docs.oracle.com/cd/B19306_01/server.102/b14231/schema.htm
You use the Segment Advisor to identify segments that would benefit from online segment shrink. Only segments in locally managed tablespaces with automatic segment space management (ASSM) are eligible.