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