GV$ASM_DISKGROUP_STAT

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'),
g.totmb_kfgrp,           -- TOTAL_MB NUMBER
g.freemb_kfgrp,          -- FREE_MB NUMBER
g.minspc_kfgrp,          -- REQUIRED_MIRROR_FREE_MB NUMBER
g.usable_kfgrp,          -- USABLE_FILE_MB NUMBER
g.offline_kfgrp,         -- OFFLINE_DISKS NUMBER
decode                   -- UNBALANCED VARCHAR2(1)
  (g.unbal_kfgrp, 0, 'N', 'Y'),
g.compat_kfgrp,          -- COMPATIBILITY VARCHAR2(60)
g.dbcompat_kfgrp         -- DATABASE_COMPATIBILITY VARCHAR2(60)
from
x$kfgrp_stat g 
where
state_kfgrp != 0
home |  up  |  mailbox