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.