« SQL Performance Analyzer and Database Replay are available for pre 11g Releases | Main | RAC and ASM on Linux Forum, July 16, Sheraton Hotel, Tel Aviv »

Manually changing rebalance power on an ongoing ASM rebalance operation

A couple of times I've removed ASM disks from a diskgroup and found that the rebalance operation will take too long.

This is not a problem when you don't want to disturb online users, the rebalance process only locks for writes 1mb of data at a time, so letting the rebalance to run slowly has no performance impact.

My problem was that I needed to free the disks as fast as possible in order to finish some IO tests within a limited timeframe.

The procedure to change the rebalance power of an ongoing operation is very simple:

alter diskgroup DATADG rebalance power 6;

After that the rebalance operation will restart with the new set rebalance power.

For a complete example check this document:

Changing the rebalance power of an ongoing rebalance operation

TrackBack

TrackBack URL for this entry:
http://blogs.oracle.com/mte1521/mt-tb.cgi/5187

Comments (1)

Thanks for the tip. Didn't know you could remove the asm disk without disturbing other users. Takes ages otherwise.

Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)

About This Entry

This page contains a single entry from the blog posted on July 2, 2008 11:28 AM.

The previous post in this blog was SQL Performance Analyzer and Database Replay are available for pre 11g Releases.

The next post in this blog is RAC and ASM on Linux Forum, July 16, Sheraton Hotel, Tel Aviv.

Many more can be found on the main index page or by looking through the archives.

Top Tags

Powered by
Movable Type and Oracle