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.
C definitely
But don’t know if B is also correct as it asks for 2.
A C
BC