Wednesday, July 30, 2025

ASM: How much time the rebalance will continue?

When planning ASM changes/downtimes every DBA need to answer the query  "how much time the rebalance will continue ?". It turns out that to answer this question, you need to execute two commands only:

EXPLAIN WORK FOR + specify your ALTER DISKGROUP command, for example, alter diskgroup DATAC1 drop disk DISK1

And then query the V$ASM_ESTIMATE view:

EXPLAIN WORK FOR alter diskgroup DATAC1 drop disk DISK1;

SELECT est_work FROM V$ASM_ESTIMATE;
EST_WORK
--------
    421

 

 

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

ASM: How much time the rebalance will continue?

When planning  ASM  changes/downtimes every DBA need to answer the query  "how much time the rebalance will continue ?". It turns...