Rebalance Disk Group
Go Up to [[Available object actions by DBMS{{#if:||{{{2}}}}}]]
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.
