DBA Hub

📋Steps in this guide1/1

Change asm rebalance power

-- Default value of asm_power_limit.

oracle configurationintermediate
by OracleDba
15 views
1

Change asm rebalance power

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
-- Default value of asm_power_limit.
SQL>
show parameter asm_power_limit
NAME                                 TYPE        VALUE
------------------------------------ ----------- -----------------------------
asm_power_limit                      integer     1
-- Check for ongoing rebalance operations and their power.
select INST_ID,GROUP_NUMBER, OPERATION, STATE, POWER, EST_RATE, EST_MINUTES from GV$ASM_OPERATION;
- Alter the asm rebalance.
alter diskgroup SALDATA rebalance power 4;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!