The command returns immediately and the formatting and rebalancing continue in the
background. You then check the status of the rebalance operation by checking the view V$ASM_
OPERATION:
SQL> select group_number, operation, state, power, actual,
2 sofar, est_work, est_rate, est_minutes from v$asm_operation;
GROUP_NUMBER OPERA STAT POWER ACTUA SOFAR EST_WORK EST_RATE EST_MINUTES
------------ ----- ---- ----- ----- ----- -------- -------- -----------
1 REBAL RUN 1 1 3 964 60 16
Chapter 4: Physical Database Layouts and Storage Management 113
Because the estimate for completing the rebalance operation is 16 minutes, you decide to
allocate more resources to the rebalance operation and change the power limit for this particular
rebalance operation:
SQL> alter diskgroup data rebalance power 8;
Diskgroup altered.
Checking the status of the rebalance operation confirms that the estimated time to completion
has been reduced to four minutes instead of 16:
SQL> select group_number, operation, state, power, actual,
2 sofar, est_work, est_rate, est_minutes from v$asm_operation;
GROUP_NUMBER OPERA STAT POWER ACTUA SOFAR EST_WORK EST_RATE EST_MINUTES
------------ ----- ---- ----- ----- ----- -------- -------- -----------
1 REBAL RUN 8 8 16 605 118 4
About four minutes later, you check the status once more:
SQL> /
no rows selected
Finally, you can confirm the new disk configuration from the V$ASM_DISK and V$ASM_
DISKGROUP views:
SQL> select group_number, disk_number, name,
2 failgroup, create_date, path from v$asm_disk;
GROUP_NUMBER DISK_NUMBER NAME FAILGROUP CREATE_DA PATH
------------ ----------- ---------- ---------- --------- ---------------
1 2 D1C D1FG3 13-JUL-07 /dev/raw/raw8
3 2 D2C FG3 13-JUL-07 /dev/raw/raw7
3 1 D2B FG2 13-JUL-07 /dev/raw/raw6
3 0 D2A FG1 13-JUL-07 /dev/raw/raw5
2 1 RECOV_0001 RECOV_0001 08-JUL-07 /dev/raw/raw4
2 0 RECOV_0000 RECOV_0000 08-JUL-07 /dev/raw/raw3
1 1 DATA_0001 DATA_0001 08-JUL-07 /dev/raw/raw2
1 0 DATA_0000 DATA_0000 08-JUL-07 /dev/raw/raw1
8 rows selected.
Pages:
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218