ASM has the ability to rebalance data across the disks whenever a disk is added,dropped or replaced.
The performance of rebalance operation is controlled by initialization parameter ASM_POWER_LIMIT.
ASM_POWER_LIMIT Parameter
Default value 1
Range of Values 0 to 11 (Prior to 11gR2)
Range of Values 0 to 1024(From 11gR2)
For 10g Databases:
SQL> alter diskgroup DG1 rebalance power 12;
alter diskgroup DG1 rebalance power 12
*
ERROR at line 1:
ORA-15102: invalid POWER expression
SQL> alter diskgroup DG1 rebalance power 11;
Diskgroup altered.
For 11g AND 12c Databases
SQL> alter diskgroup DG1 rebalance power 1025;
alter diskgroup DG1 rebalance power 1025
*
ERROR at line 1:
ORA-15102: invalid POWER expression
SQL> alter diskgroup DG1 rebalance power 1024;
Diskgroup altered.
The performance of rebalance operation is controlled by initialization parameter ASM_POWER_LIMIT.
ASM_POWER_LIMIT Parameter
Default value 1
Range of Values 0 to 11 (Prior to 11gR2)
Range of Values 0 to 1024(From 11gR2)
For 10g Databases:
SQL> alter diskgroup DG1 rebalance power 12;
alter diskgroup DG1 rebalance power 12
*
ERROR at line 1:
ORA-15102: invalid POWER expression
SQL> alter diskgroup DG1 rebalance power 11;
Diskgroup altered.
For 11g AND 12c Databases
SQL> alter diskgroup DG1 rebalance power 1025;
alter diskgroup DG1 rebalance power 1025
*
ERROR at line 1:
ORA-15102: invalid POWER expression
SQL> alter diskgroup DG1 rebalance power 1024;
Diskgroup altered.
The higher the value of rebalancing power, faster would be rebalancing operation.
I am truly thankful to the owner of this web site who has shared this fantastic piece of writing at at this place.
Hi there to all, for the reason that I am genuinely keen of reading this website’s post to be updated on a regular basis. It carries pleasant stuff.
I really like reading through a post that can make men and women think. Also, thank you for allowing me to comment!
For the reason that the admin of this site is working, no uncertainty very quickly it will be renowned, due to its quality contents.