Disk Group Percent Imbalance % And Cannot Be Fixed (Doc ID 2692830.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

For diskgroup named DBFS_GS -> Disk Group Percent Imbalance is %30
tried to execute following SQL but it didn't help:

alter diskgroup DBFS_DG rebalance power 8;

Still the metric shows %30 percent imbalance.

Even after running the below query it reports the correct value %30 imbalance.

set verify off
clear columns
define asm_disk = v$asm_disk_stat
define asm_diskgroup = v$asm_diskgroup_stat
column "Diskgroup" format A30
column "Diskgroup" Heading " Columns Described in Script||Diskgroup Name"
column  "Imbalance" format 99.9 Heading "Percent|Imbalance"
column  "Varience" format 99.9 Heading "Percent|Disk Size|Varience"
column  "MinFree" format 99.9 Heading "Minimum|Percent|Free"
column "DiskCnt" format 9999 Heading "Disk|Count"
column  "Type"  format A10 Heading "Diskgroup|Redundancy"
select
g.name
"Diskgroup", 100*(max((d.total_mb-d.free_mb +
(128*g.allocation_unit_size/1048576))/(d.total_mb +
(128*g.allocation_unit_size/1048576)))-min((d.total_mb-d.free_mb +
(128*g.allocation_unit_size/1048576))/(d.total_mb +
(128*g.allocation_unit_size/1048576))))/max((d.total_mb-d.free_mb +
(128*g.allocation_unit_size/1048576))/(d.total_mb +
(128*g.allocation_unit_size/1048576)))
"Imbalance", 100*(max(d.total_mb)-min(d.total_mb))/max(d.total_mb)
"Varience", 100*(min(d.free_mb/d.total_mb)) "MinFree",count(*)
"DiskCnt",g.type "Type"
from &asm_disk d , &asm_diskgroup g
where
d.group_number = g.group_number and
d.failgroup_type = 'REGULAR' and
d.group_number <> 0 and
d.state = 'NORMAL' and
d.mount_status = 'CACHED'
group by
g.name ,
g.type;

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.