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')