Which two storage-tiering actions might be automated when using information Lifecycle Management (ILM) to automate data movement?

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?

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.



Leave a Reply 3

Your email address will not be published. Required fields are marked *


anonym

anonym

C definitely

But don’t know if B is also correct as it asks for 2.