Time taken by rebalance process of ASM in Oracle
File extents relocation:
In example of ASM, I drop one of the disks with the default rebalance power. I then query GV$ASM_OPERATION to check the estimated completion time (EST_MINUTES):
1. Check the ASM power limit parameter in the database.
SQL> show parameter power NAME TYPE VALUE --------------- ------- ---------------- asm_power_limit integer 1
2. Drop the disk from the disk group as below.
alter diskgroup DATA1 drop disk DATA1_01;
Diskgroup altered.
3. Check the time taken by the ASM rebalance operation(estimated time to complete is 26 minutes) :
select INST_ID, OPERATION, STATE, POWER, SOFAR, EST_WORK, EST_RATE, EST_MINUTES from GV$ASM_OPERATION where GROUP_NUMBER=1;
INST_ID OPERA STAT POWER SOFAR EST_WORK EST_RATE EST_MINUTES ------- ----- ---- ----- ----- -------- -------- ----------- 3 REBAL WAIT 1 2 REBAL RUN 1 516 53736 2012 26 4 REBAL WAIT 1