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.
Answer is A,C,E
B is wrong as segment advisor can’t shrink for tables in dictionary managed tablespaces
D is wrong is segment advisor can’t recommend for chained rows. It can only detect
For me the correct answers are only A and C.
Agree with OraEXP Test:
B is wrong as segment advisor can’t shrink for tables in dictionary managed tablespaces
D is wrong is segment advisor can’t recommend for chained rows. It can only detect
But for me E is also wrong since free list is a characteristic of Manual Segment Space Management and Shrink operations can be performed only on segments in locally managed tablespaces with automatic segment space management (ASSM)
ACD
D see
http://docs.oracle.com/cd/B28359_01/server.111/b28310/schema003.htm#ADMIN11601
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.
12c docs https://docs.oracle.com/database/121/ADMIN/schema.htm#ADMIN11601
I go with ACD. I conclude following things;
1) for tables under dictionary managed tablesapce can only be shrink using ONLINE REDEFINITION.
2) for tables under ASSM – the shrinking can be done either ONLINE REDEF or SHRINK COMPRESS;
A & C are correct
D is somewhere close to ( though not exactly correct) .
ACD