GV$ASM_DISKGROUP definition in Oracle Database 11.2
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, decode(bitand(g.lflags_kfgrp, 1), 1, 'QUIESCING', 'MOUNTED'), 6, 'DISMOUNTING', 7, 'CONNECTED', 8, 'BROKEN', 9, 'CONNECTING', 10, 'BREAKING', 11, 'DROPPING', 12, 'DROPPING', 255, 'RESTRICTED'),
  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.hotmb_kfgrp,                           -- HOT_USED_MB NUMBER
  g.coldmb_kfgrp,                          -- COLD_USED_MB NUMBER
  g.minspc_kfgrp,                          -- REQUIRED_MIRROR_FREE_MB NUMBER
  g.usable_kfgrp,                          -- USABLE_FILE_MB NUMBER
  g.offline_kfgrp,                         -- OFFLINE_DISKS NUMBER
  g.compat_kfgrp,                          -- COMPATIBILITY VARCHAR2(60)
  g.dbcompat_kfgrp,                        -- DATABASE_COMPATIBILITY VARCHAR2(60)
  decode(                                  -- VOTING_FILES VARCHAR2(1)
    bitand(g.flags_kfgrp, 2048), 2048, 'Y', 'N') 
from
  x$kfgrp g
where
  state_kfgrp != 0

home |  up