Tag Archives: check rebalance operation estimate

Time taken by rebalance process of ASM in Oracle

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