- 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
Post a Comment