You use the segment advisor to help determine objects for which space may be reclaimed.
Which three statements are true about the advisor given by the segment advisor?
A.
It may advise the use of online table redefinition for tables in dictionary managed tablespace.
B.
It may advise the use of segment shrink for tables in dictionary managed tablespaces it the no
chained rows.
C.
It may advise the use of online table redefinition for tables in locally managed tablespaces
D.
It will detect and advise about chained rows.
E.
It may advise the use of segment shrink for free list managed tables.
Explanation:
The Segment Advisor generates the following types of advice:
* If 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 (C).
* (D) If the Segment Advisor encounters a table with row chaining above a certain threshold, it
records that fact that the table has an excess of chained rows.
B – TRUE – only advise
If 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.
C – TRUE
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.
D – TRUE
If the Segment Advisor encounters a table with row chaining above a certain threshold, it records that fact that the table has an excess of chained rows.
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.
So E is incorrect.
The Segment Advisor generates the following types of advice:
•If 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.
•If the Segment Advisor encounters a table with row chaining above a certain threshold, it records that fact that the table has an excess of chained rows.
So A, C and D should be the correct answers.
ACD
BCD
ACD
B is incorrect. “Shrink operations can be performed only on segments in locally managed tablespaces with automatic segment space management (ASSM).”
http://docs.oracle.com/cd/B19306_01/server.102/b14231/schema.htm#CBBBIADA
A C and D appears to be correct.
looks ACD is correct
ACD is final answer
ACD
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. Other restrictions on segment type exist. For more information, see “Shrinking Database Segments Online”. Hence, C is correct.
B is incorrect.
If a table with reclaimable space is not eligible for online segment shrink, or if you want to make changes to logical or physical attributes of the table while reclaiming space, you can use online table redefinition as an alternative to segment shrink. Online redefinition is also referred to as reorganization. Unlike online segment shrink, it requires extra disk space to be allocated. Hence Choice A is correct.
The Segment Advisor generates the following types of advice:
If 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.
If the Segment Advisor encounters a table with row chaining above a certain threshold, it records that fact that the table has an excess of chained rows. Hence, D is correct.
The Segment Advisor flags only the type of row chaining that results from updates that increase row length
Final Answers: A, C, D
acd
CDE..
Segment Advisor will not take care of the Dictionary Managed tablespaces.
ACD
E is wrong because free list is used by Manual Segment Space Management, not automatic segment space management
ACD
A C D
ACD