Change the ASM rebalance power in Oracle

 

  • Check the default value of ASM rebalance power in Oracle.

SQL> show parameter asm_power_limit

NAME TYPE VALUE
------------------------------------ ----------- ---
asm_power_limit integer 1

  • Check the running ASM rebalance operation.

select INST_ID,GROUP_NUMBER, OPERATION, STATE, POWER, EST_RATE, EST_MINUTES from GV$ASM_OPERATION;

  • Change or Increase the ASM Rebalance operation power for diskgroup level.

alter diskgroup DATA rebalance power 4;

Comments