select fs_name, -- FS_NAME VARCHAR2(1024) available_time, -- AVAILABLE_TIME DATE block_size, -- BLOCK_SIZE NUMBER state, -- STATE VARCHAR2(13) corrupt, -- CORRUPT VARCHAR2(5) num_vol, -- NUM_VOL NUMBER total_size, -- TOTAL_SIZE NUMBER total_free, -- TOTAL_FREE NUMBER total_snap_space_usage -- TOTAL_SNAP_SPACE_USAGE NUMBER from gv$asm_filesystem where inst_id = USERENV('Instance')