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 Man

The correct answer is 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. 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_PER

Managing Database Storage Structures

Question

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?

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
CThe movement of some segments to a target tablespace with a higher degree of compression, on
DSetting the target tablespace offline
EThe movement of some blocks to a target tablespace with a lower degree of compression, on a

How the community answered

(59 responses)

A
3% (2)
B
71% (42)
D
17% (10)
E
8% (5)

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.

Topics

#Information Lifecycle Management#ILM#storage tiering#compression

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice