12C对ASM rebalance操作的优化

SQL> explain work for alter diskgroup crs drop disk crs_0000;

Explained.

SQL> select * from v$asm_estimate;

GROUP_NUMBER STATEMENT_ID                   TIMESTAMP   EST_WORK     CON_ID
------------ ------------------------------ --------- ---------- ----------
           1                                14-SEP-16       6357          0

SQL> 

SQL> explain work set statement_id=‘online‘ for alter diskgroup data online disk data_0000;

explained.

SQL> select est_work from v$asm_estimate where statement_id=‘online‘;
est_work
--------
     635