1.21 ASM_POWER_LIMIT

ASM_POWER_LIMIT specifies the maximum power on an Oracle ASM instance for disk rebalancing.

Property Description

Parameter type

Integer

Default value

1

Modifiable

ALTER SESSION, ALTER SYSTEM

Modifiable in a PDB

No

Range of values

0 to 11Foot 1

Basic

No

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 Oracle Automatic Storage Management (Oracle ASM) instance.

  • In an Oracle Exadata or Oracle Data Appliance environment, you cannot set this parameter to 0.

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.

See Also:

Oracle Automatic Storage Management Administrator's Guide for more information about using this parameter