|
CodeListing 3: Checking on a rebalancing operation
SQL> ALTER DISKGROUP mydata
2 ADD FAILGROUP mydata01 DISK '\\.\J:'
3 FAILGROUP mydata02 DISK '\\.\K:';
Diskgroup altered.
SQL> SELECT group_number, operation, state, est_work,
sofar, est_rate, est_minutes
2 FROM v$asm_operation;
GROUP_NUMBER OPERA STAT EST_WORK SOFAR EST_RATE EST_MINUTES
------------ ----- ---- -------- ----- -------- -----------
1 REBAL WAIT 85 0 188 0
SQL> /
GROUP_NUMBER OPERA STAT EST_WORK SOFAR EST_RATE EST_MINUTES
------------ ----- ---- -------- ----- -------- -----------
1 REBAL WAIT 85 29 188 0
SQL> /
GROUP_NUMBER OPERA STAT EST_WORK SOFAR EST_RATE EST_MINUTES
------------ ----- ---- -------- ----- -------- -----------
1 REBAL WAIT 85 91 287 0
|