Wednesday, September 17, 2008

ASM rebalance power.

To increase the power of the rebalancing operation on the fly you can do the following (this has been done for ASM_ORADATA52)

ALTER DISKGROUP ASM_ORADATA52 REBALANCE POWER 8 NOWAIT;

You can monitor the rebalancing by querying v$asm_operation via sqlplus (ASM environment)

select * from v$asm_operation;
GROUP_NUMBER OPERA STAT POWER ACTUAL SOFAR EST_WORK EST_RATE
------------ ----- ---- ---------- ---------- ---------- ---------- ----------
EST_MINUTES
-----------
2 REBAL RUN 8 8 1320 170597 393
430