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 after the segments are moved

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 T3S percent
used

D.
Taking the target tablespace offline after the segments are moved

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



Leave a Reply 6

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


Siegfried

Siegfried

B,C
The threshold for activating tiering policies is based on two parameters:

TBS PERCENT USED
TBS PERCENT FREE

Both values can be controlled by the DBMS_ILM_ADMIN package.

TBS PERCENT USED and TBS PERCENT FREE default to 85 and 25, respectively. Hence, whenever the source tablespace’s usage percentage goes beyond 85 percent, any tiering policy specified on its objects will be executed and objects will be moved to the target tablespace until the source tablespace becomes at least 25 percent free. Note that it is possible to add a custom condition to tiering policies to enable movement of data based on conditions other than how full the tablespace is.
In addition, the READ ONLY option must be explicitly specified for the target tablespace.