which segments to shrink?

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 segments to shrink?

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 segments to shrink?

A.
SQL Access Advisor

B.
Automatic Database Diagnostic Monitor (ADDM)

C.
Segment Resource Estimation

D.
Segment Advisor

E.
SQL Tuning Advisor



Leave a Reply 0

Your email address will not be published. Required fields are marked *