From the following listing you can find how to list asm disks, adding and removing disks from a disk group and watch the rebalance operation from v$asm_operation view.
By changing the init parameter "asm_power_limit", asm rebalance operations are significantly getting faster. The difference can obviously be seen by setting the parameter to 10 (instead of default value 1) and then giving the same operations that need rebalance. Of course this was not an online system so we may want asm to exhaust all the IO for rebalancing. But in case of production systems there can be unwanted IO performance degradation of the application by this kind of aggressive setting.
SQL> select group_number,state,name,total_mb from v$asm_disk; GROUP_NUMBER STATE NAME TOTAL_MB ------------ -------- -------------------- ---------- 0 NORMAL 924 0 NORMAL 924 0 NORMAL 924 0 NORMAL 924 1 NORMAL DATA_0009 614300 1 NORMAL DATA_0008 614290 1 NORMAL DATA_0002 614290 1 NORMAL DATA_0001 614290 1 NORMAL DATA_0000 614290 1 NORMAL DATA_0007 614290 1 NORMAL DATA_0006 614290 1 NORMAL DATA_0005 614290 1 NORMAL DATA_0004 614290 1 NORMAL DATA_0003 614290 14 rows selected. SQL> alter diskgroup DATA drop disk DATA_0000; Diskgroup altered. SQL> alter diskgroup DATA drop disk DATA_0001; Diskgroup altered. SQL> select group_number,state,name,total_mb,label,path from v$asm_disk; GROUP_NUMBER STATE NAME TOTAL_MB LABEL PATH ------------ -------- --------------- ---------- ----- -------------------------------------------------- 0 NORMAL 924 /dev/rdsk/c6t600601607D731F00A8833C0377FEDD11d0s0 0 NORMAL 924 /dev/rdsk/c6t600601607D731F00A7833C0377FEDD11d0s0 0 NORMAL 924 /dev/rdsk/c6t600601607D731F00A6833C0377FEDD11d0s0 0 NORMAL 924 /dev/rdsk/c6t600601607D731F006596A6CD2CE9DD11d0s0 1 NORMAL DATA_0009 614300 /dev/rdsk/c6t600601607D731F00D994060263E8DD11d0s0 1 NORMAL DATA_0008 614290 /dev/rdsk/c6t600601607D731F00D894060263E8DD11d0s0 1 NORMAL DATA_0002 614290 /dev/rdsk/c6t600601607D731F006A37A4E0A0E7DD11d0s0 1 DROPPING DATA_0001 614290 /dev/rdsk/c6t600601607D731F006937A4E0A0E7DD11d0s0 1 DROPPING DATA_0000 614290 /dev/rdsk/c6t600601607D731F006837A4E0A0E7DD11d0s0 1 NORMAL DATA_0007 614290 /dev/rdsk/c6t600601607D731F007608DB3DA0E7DD11d0s0 1 NORMAL DATA_0006 614290 /dev/rdsk/c6t600601607D731F007508DB3DA0E7DD11d0s0 1 NORMAL DATA_0005 614290 /dev/rdsk/c6t600601607D731F007408DB3DA0E7DD11d0s0 1 NORMAL DATA_0004 614290 /dev/rdsk/c6t600601607D731F007308DB3DA0E7DD11d0s0 1 NORMAL DATA_0003 614290 /dev/rdsk/c6t600601607D731F007208DB3DA0E7DD11d0s0 SQL> select * from v$asm_operation; OPERA STAT POWER ACTUAL SOFAR EST_WORK EST_RATE EST_MINUTES ----- ---- ---------- ---------- ---------- ---------- ---------- ----------- REBAL RUN 10 10 7198 12996 260 22 REBAL RUN 10 10 7679 12979 242 21 REBAL RUN 10 10 9286 12930 201 18 REBAL RUN 10 10 11647 12899 237 5 SQL> select * from v$asm_operation; no rows selected SQL> select group_number,state,name,total_mb,label,path from v$asm_disk; GROUP_NUMBER STATE NAME TOTAL_MB LABEL PATH ------------ -------- --------------- ---------- ----- -------------------------------------------------- 0 NORMAL 924 /dev/rdsk/c6t600601607D731F00A8833C0377FEDD11d0s0 0 NORMAL 924 /dev/rdsk/c6t600601607D731F00A7833C0377FEDD11d0s0 0 NORMAL 924 /dev/rdsk/c6t600601607D731F00A6833C0377FEDD11d0s0 0 NORMAL 614290 /dev/rdsk/c6t600601607D731F006937A4E0A0E7DD11d0s0 0 NORMAL 614290 /dev/rdsk/c6t600601607D731F006837A4E0A0E7DD11d0s0 0 NORMAL 924 /dev/rdsk/c6t600601607D731F006596A6CD2CE9DD11d0s0 1 NORMAL DATA_0009 614300 /dev/rdsk/c6t600601607D731F00D994060263E8DD11d0s0 1 NORMAL DATA_0008 614290 /dev/rdsk/c6t600601607D731F00D894060263E8DD11d0s0 1 NORMAL DATA_0002 614290 /dev/rdsk/c6t600601607D731F006A37A4E0A0E7DD11d0s0 1 NORMAL DATA_0007 614290 /dev/rdsk/c6t600601607D731F007608DB3DA0E7DD11d0s0 1 NORMAL DATA_0006 614290 /dev/rdsk/c6t600601607D731F007508DB3DA0E7DD11d0s0 1 NORMAL DATA_0005 614290 /dev/rdsk/c6t600601607D731F007408DB3DA0E7DD11d0s0 1 NORMAL DATA_0004 614290 /dev/rdsk/c6t600601607D731F007308DB3DA0E7DD11d0s0 1 NORMAL DATA_0003 614290 /dev/rdsk/c6t600601607D731F007208DB3DA0E7DD11d0s0 SQL> alter diskgroup DATA add disk '/dev/rdsk/c6t600601607D731F006837A4E0A0E7DD11d0s0'; Diskgroup altered. SQL> select group_number,state,name,total_mb,label,path from v$asm_disk; GROUP_NUMBER STATE NAME TOTAL_MB LABEL PATH ------------ -------- --------------- ---------- ----- -------------------------------------------------- 0 NORMAL 924 /dev/rdsk/c6t600601607D731F00A8833C0377FEDD11d0s0 0 NORMAL 924 /dev/rdsk/c6t600601607D731F00A7833C0377FEDD11d0s0 0 NORMAL 924 /dev/rdsk/c6t600601607D731F00A6833C0377FEDD11d0s0 0 NORMAL 614290 /dev/rdsk/c6t600601607D731F006937A4E0A0E7DD11d0s0 0 NORMAL 924 /dev/rdsk/c6t600601607D731F006596A6CD2CE9DD11d0s0 1 NORMAL DATA_0009 614300 /dev/rdsk/c6t600601607D731F00D994060263E8DD11d0s0 1 NORMAL DATA_0008 614290 /dev/rdsk/c6t600601607D731F00D894060263E8DD11d0s0 1 NORMAL DATA_0002 614290 /dev/rdsk/c6t600601607D731F006A37A4E0A0E7DD11d0s0 1 NORMAL DATA_0007 614290 /dev/rdsk/c6t600601607D731F007608DB3DA0E7DD11d0s0 1 NORMAL DATA_0006 614290 /dev/rdsk/c6t600601607D731F007508DB3DA0E7DD11d0s0 1 NORMAL DATA_0005 614290 /dev/rdsk/c6t600601607D731F007408DB3DA0E7DD11d0s0 1 NORMAL DATA_0004 614290 /dev/rdsk/c6t600601607D731F007308DB3DA0E7DD11d0s0 1 NORMAL DATA_0003 614290 /dev/rdsk/c6t600601607D731F007208DB3DA0E7DD11d0s0 1 NORMAL DATA_0000 614290 /dev/rdsk/c6t600601607D731F006837A4E0A0E7DD11d0s0 SQL> show parameter asm_power_limit; NAME TYPE VALUE ------------------------------- ----------- ------------------------- asm_power_limit integer 1 SQL> alter system set asm_power_limit=10; System altered. SQL> show parameter asm_power_limit; NAME TYPE VALUE ------------------------------- ----------- ------------------------- asm_power_limit integer 10 SQL>
No comments:
Post a Comment