You can use Segment Advisor to…

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 _______.

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.
add data files to the tablespace

B.
identify the segments that you should shrink

C.
modify the storage parameters for the tablespace

D.
automatically shrink the segments with unused space

E.
check the alerts generated for the table space that is running low on space

Explanation:
The Segment Advisor determines that an object has a significant amount of free space, it recommends online segment shrink. If the object is a table that is not eligible for shrinking, as in the case of a table in a tablespace without automatic segment space management, the Segment Advisor recommends online table redefinition.

REF: Oracle(r) 10g Administrator Guide, 14-16



Leave a Reply 0

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