Find 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 adisk from the diskgroup 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

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.