oracle asm asm_power_limit,oracle.1z0-053:ASM_POWER_LIMIT

QUESTION NO: 56

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

Explanation:

ASM_POWER_LIMIT

Property

Description

Parameter type

Integer

Default value

1

Modifiable

ALTER SESSION,ALTER SYSTEM

Range of values

0to11

Oracle RAC

Multiple instances can have different

values.

Footnote 1Beginning

with Oracle Database 11gRelease 2 (11.2.0.2), if theCOMPATIBLE.ASMdisk 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_LIMITspecifies 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 thePOWERclause of a rebalance operation is not specified, then the

default power will be the value ofASM_POWER_LIMIT.