Rebalance Disk Group
Go Up to Available object actions by DBMS
This action builds and submits an ALTER DISKGROUP... REBALANCE statement with an optional POWER option. This lets you manually rebalance the disk group, distributing datafiles evenly across drives.
- Note: Before this object action is available you must have a direct connection to the ASM instance. For details, see Manage ASM Connection.
Platform Availability
- ORCL 10g
To Manually Rebalance a Disk Group
- On a connected Oracle datasource, expand the Instance and ASM nodes.
- Right-click the Disk Groups node and select Rebalance Disk Group from the context menu.
- Use the following table as a guide to understanding and modifying settings in the dialog:
| Step | Settings and tasks | |
|---|---|---|
|
Action options |
Power - If deselected, ASM executes rebalance operations at the power rate set by the ASM_POWER_LIMIT initialization parameter. If selected, you can specify the power rate using the Power value control. Power value - If Power is selected, specify a value between 0 and 11. A 0 value stops the rebalance operation and at the other extreme, 11 lets ASM execute the rebalance as quickly as possible. Wait (available as of Oracle 11GR1) - Lets you specify a WAIT/NOWAIT clause, letting you specify when during the rebalance that control is returned to the user. | |
|
Dependencies |
Lists referring and referenced objects potentially impacted by the change. For details, see Dependencies. | |
|
Preview |
Displays the DDL that will execute the object action. For details, see Preview. | |
- 4. Click Execute. For information on the scheduling option, see Scheduling.