Estimate the amount of work for rebalance operation in ASM Oracle

Estimate the amount of work for a rebalance operation

You can estimate the amount of work with v$ASM_ESTIMATE view. EST_WORK column provides an estimate of the number of allocation units that have to be moved by the rebalance operation to complete.

Note: Est_work column provide the information of allocation unit that is moved during rebalance operations.

Example of estimating the drop disk command

-- Estimate the drop disk work
EXPLAIN WORK FOR ALTER DISKGROUP diskgroup2 DROP DISK diska1;

--Check the view for estimate:
SELECT est_work FROM V$ASM_ESTIMATE;
EST_WORK
--------
5600

Example of estimating the disk online for a diskgroup

--Estimate of online the disk in a diskgroup using statement id
EXPLAIN WORK SET STATEMENT_ID='online' FOR ALTER DISKGROUP diskgroup2
ONLINE disk diska1;

--Check the view for estimate:
SELECT est_work FROM V$ASM_ESTIMATE WHERE STATEMENT_ID='online';
EST_WORK
--------
200

Please refer for rebalance operation commands in Oracle ASM: Rebalance operation in Diskgroup Oracle ASM

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.