156.What is the effect of increasing the value of the ASM_POWER_LIMIT parameter?
A. The number of DBWR processes increases
B. The number of ASMB processes increases
C. The number of DBWR_TO_SLAVES increases
D. The rebalancing operation in an ASM instance completes more quickly, but can result in higher I/O
overhead
Answer: D
A. The number of DBWR processes increases
B. The number of ASMB processes increases
C. The number of DBWR_TO_SLAVES increases
D. The rebalancing operation in an ASM instance completes more quickly, but can result in higher I/O
overhead
Answer: D
ASM_POWER_LIMIT
Property | Description |
---|---|
Parameter type | Integer |
Default value | 1 |
Modifiable | ALTER SESSION , ALTER SYSTEM |
Range of values | 0 to 11 Foot 1 |
Oracle RAC | Multiple instances can have different values. |
Footnote 1 Beginning with Oracle Database 11g Release 2 (11.2.0.2), if the COMPATIBLE
.ASM
disk group attribute is set to 11.2.0.2 or higher, then the range of values is 0 to 1024.
Note:
This parameter may only be specified in an Automatic Storage Management instance. ASM_POWER_LIMIT
specifies the maximum power on an Automatic Storage Management instance for disk rebalancing. The higher the limit, the faster rebalancing will complete. Lower values will take longer, but consume fewer processing and I/O resources.
If the POWER
clause of a rebalance operation is not specified, then the default power will be the value of ASM_POWER_LIMIT
.