Wednesday, September 24, 2008

ASM_POWER_LIMIT

Property

Description

Parameter type

Integer

Default value

1

Modifiable

ALTER SESSION, ALTER SYSTEM

Range of values

0 to 11

Real Application Clusters

Multiple instances can have different values.

Note:

1. 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.

2. This parameter was introduced in 10g.

3. Query for the current value of the parameter

select name, value, isdefault, isses_modifiable, issys_modifiable,

isinstance_modifiable, isdeprecated, description

from v$parameter where upper(name) = 'ASM_POWER_LIMIT';

NAME

VALUE

IS

DEFAULT

ISSES_

MODIFIABLE

ISSYS_

MODIFIABLE

ISINSTANCE_

MODIFIABLE

IS

DEPRECATED

DESCRIPTION

asm_power_limit

1

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

number of processes for disk rebalancing

Oracle initializatoin parameters

No comments:

Post a Comment