In your Database, the TBS PERCENT USED parameter is set to 60 and the TBS PERCENT
FREE parameter is set to 20.
Which two storage-tiering actions might be automated when using information Lifecycle
Management (ILM) to automate data movement?
A.
The movement of all segments to a target tablespace with a higher degree of compression, on
a different storage tier, when the source tablespace exceeds TBS PERCENT USED
B.
Setting the target tablespace to read-only
C.
The movement of some segments to a target tablespace with a higher degree of compression,
on a different storage tier, when the source tablespace exceeds TBS PERCENT USED
D.
Setting the target tablespace offline
E.
The movement of some blocks to a target tablespace with a lower degree of compression, on a
different storage tier, when the source tablespace exceeds TBS PERCENT USED
Explanation:
The value for TBS_PERCENT_USED specifies the percentage of the tablespace quota when a
tablespace is considered full. The value for TBS_PERCENT_FREE specifies the targeted free
percentage for the tablespace. When the percentage of the tablespace quota reaches the value of
TBS_PERCENT_USED, ADO begins to move data so that percent free of the tablespace quota
approaches the value of TBS_PERCENT_FREE. This action by ADO is a best effort and not a
guarantee.
The answers are correct. (B and C)
The move scope is segment level only not block level.
When a segment is moved to another tablespace, another option is to set the target tablespace
to READ ONLY after the object is moved. This is very beneficial during backup, because Oracle
Recovery Manager (RMAN) has the ability to skip such tablespaces.
B and C
BC
I think C and E
ILM actions compression , move or move and compression
from ado whitepaper :”ADO policies can be specified at the segment or row level for tables and table partitions.” (E is wrong)
“Another option when moving a segment to another tablespace is to set the target tablespace to READ ONLY after the object is moved.”
BC
BC is final answer
BC
Alessandro, did you pass
Guys , kindly share your answers who passed the exam .
BC
BC
B,C