GV$ASM_DISKGROUP definition in Oracle 10g / www.oracledba.ru
GV$ASM_DISKGROUP
select
g.inst_id, -- INST_ID NUMBER
g.number_kfgrp, -- GROUP_NUMBER NUMBER
g.name_kfgrp, -- NAME VARCHAR2(30)
g.sector_kfgrp, -- SECTOR_SIZE NUMBER
g.blksize_kfgrp, -- BLOCK_SIZE NUMBER
g.ausize_kfgrp, -- ALLOCATION_UNIT_SIZE NUMBER
decode -- STATE VARCHAR2(11)
(g.state_kfgrp, 0, 'INVALID', 1, 'UNKNOWN', 2, 'DISMOUNTED', 3, 'CREATING', 4, 'MOUNTING', 5, 'MOUNTED', 6, 'DISMOUNTING', 7, 'CONNECTED', 8, 'BROKEN', 9, 'CONNECTING', 10, 'BREAKING', 11, 'DROPPING'),
decode -- TYPE VARCHAR2(6)
(g.type_kfgrp, 1, 'EXTERN', 2, 'NORMAL', 3, 'HIGH'),
(
select
sum (d.totmb_kfdsk)
from
x$kfdsk d
where
g.number_kfgrp = d.grpnum_kfdsk),
(
select
sum (d.totmb_kfdsk - d.usedmb_kfdsk)
from
x$kfdsk d
where
g.number_kfgrp = d.grpnum_kfdsk)
from
x$kfgrp g
where
state_kfgrp != 0