1. Database Reference
  2. Initialization Parameters
  3. Initialization Parameters
  4. ASM_POWER_LIMIT

1.18 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

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