DBA Data[Home] [Help]

VIEW: SYS.GV_$ASM_FILESYSTEM

Source

View Text - Preformatted

select "INST_ID","FS_NAME","AVAILABLE_TIME","BLOCK_SIZE","STATE","CORRUPT","NUM_VOL","TOTAL_SIZE","TOTAL_FREE","TOTAL_SNAP_SPACE_USAGE","REPLSTATE","CON_ID" from gv$asm_filesystem
View Text - HTML Formatted

SELECT "INST_ID"
, "FS_NAME"
, "AVAILABLE_TIME"
, "BLOCK_SIZE"
, "STATE"
, "CORRUPT"
, "NUM_VOL"
, "TOTAL_SIZE"
, "TOTAL_FREE"
, "TOTAL_SNAP_SPACE_USAGE"
, "REPLSTATE"
, "CON_ID"
FROM GV$ASM_FILESYSTEM