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…

Question

Options

• AThe movement of all segments to a target tablespace with a higher degree of compression, on a
• BSetting the target tablespace to read-only after the segments are moved
• CThe movement of some segments to a target tablespace with a higher degree of compression, on
• DTaking the target tablespace offline after the segments are moved
• EThe movement of some blocks to a target tablespace with a lower degree of compression, on a

• A
  14% (5)
• B
  74% (26)
• D
  9% (3)
• E
  3% (1)

Explanation

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.

No community discussion yet for this question.