GV$ASM_FILESYSTEM definition in Oracle Database 11.2
GV$ASM_FILESYSTEM

select
  xv.inst_id,                              -- INST_ID NUMBER
  xv.name_kfvacfs,                         -- FS_NAME VARCHAR2(1024)
  to_date(                                 -- AVAILABLE_TIME DATE
    xv.time_kfvacfs,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  xv.blksz_kfvacfs/(1024),                 -- BLOCK_SIZE NUMBER
  decode(                                  -- STATE VARCHAR2(13)
    xv.state_kfvacfs, 0, 'NOT AVAILABLE', 1, 'AVAILABLE', 2, 'OFFLINE'),
  decode(                                  -- CORRUPT VARCHAR2(5)
    xv.corrupt_kfvacfs, 1, 'TRUE', 0, 'FALSE'),
  xv.numvol_kfvacfs,                       -- NUM_VOL NUMBER
  xv.totsz_kfvacfs/(1024*1024),            -- TOTAL_SIZE NUMBER
  xv.totfree_kfvacfs/(1024*1024),          -- TOTAL_FREE NUMBER
  xv.totsnap_kfvacfs/(1024*1024)           -- TOTAL_SNAP_SPACE_USAGE NUMBER
from
  x$kfvacfs xv

home |  up