V$ASM_ACFSVOLUMES definition in Oracle Database 11.2
V$ASM_ACFSVOLUMES

select
  fs_name,                                 -- FS_NAME VARCHAR2(1024)
  vol_device,                              -- VOL_DEVICE VARCHAR2(256)
  vol_label,                               -- VOL_LABEL VARCHAR2(64)
  primary_vol,                             -- PRIMARY_VOL VARCHAR2(5)
  total_mb,                                -- TOTAL_MB NUMBER
  free_mb                                  -- FREE_MB NUMBER
from
  gv$asm_acfsvolumes
where
  inst_id = USERENV('Instance')

home |  up