GV$ASM_ACFSVOLUMES definition in Oracle Database 11.2
GV$ASM_ACFSVOLUMES

select
  xv.inst_id,                              -- INST_ID NUMBER
  xv.name_kfvacfsv,                        -- FS_NAME VARCHAR2(1024)
  xv.voldev_kfvacfsv,                      -- VOL_DEVICE VARCHAR2(256)
  xv.vollab_kfvacfsv,                      -- VOL_LABEL VARCHAR2(64)
  decode(                                  -- PRIMARY_VOL VARCHAR2(5)
    xv.privol_kfvacfsv, 0, 'FALSE', 1, 'TRUE'),
  xv.totsz_kfvacfsv/(1024*1024),           -- TOTAL_MB NUMBER
  xv.totfree_kfvacfsv/(1024*1024)          -- FREE_MB NUMBER
from
  x$kfvacfsv xv

home |  up