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.