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

E-mail this page
Printer View Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Privacy