-
Notifications
You must be signed in to change notification settings - Fork 3
Expand file tree
/
Copy pathasm-rebal-progress.sql
More file actions
25 lines (18 loc) · 1.06 KB
/
Copy pathasm-rebal-progress.sql
File metadata and controls
25 lines (18 loc) · 1.06 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
--http://asmsupportguy.blogspot.in/2012/07/when-will-my-rebalance-complete.html
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
About 10 minutes into the rebalance, the estimate is 24 minutes:
16:50:25 SQL> /
INST_ID OPERA STAT POWER SOFAR EST_WORK EST_RATE EST_MINUTES
---------- ----- ---- ---------- ---------- ---------- ---------- -----------
3 REBAL WAIT 1
2 REBAL RUN 1 19235 72210 2124 24
4 REBAL WAIT 1
While that EST_MINUTES doesn't give me much confidence, I see that the SOFAR (number of allocation units moved so far)
is going up, which is a good sign.
*******************/