You have 100 segments in the USERS tablespace. You get an alert that the USERS tablespace is running low on space. You decide to shrink some segments.
Which option would you use to determine which segment to shrink?
A.
Segment Advisor
B.
SQL Tuning Advisor
C.
SQL Access Advisor
D.
Segment Resource Estimation
E.
Automatic Database Diagnostic Monitor (ADDM)
Explanation:
The Segment Advisor identifies segments that have space available for reclamation. It performs its analysis by examining usage and growth statistics in the Automatic Workload Repository (AWR), and by sampling the data in the segment. It is configured to run automatically at regular intervals, and you can also run it on demand (manually). The regularly scheduled Segment Advisor run is known as the Automatic Segment Advisor.REF: Oracle(r) 10g Administrator Guide, 14-16
I have the same idea.