DBA Data[Home] [Help]

VIEW: SYS.V_$ASM_VOLUME

Source

View Text - Preformatted

select "GROUP_NUMBER","VOLUME_NAME","COMPOUND_INDEX","SIZE_MB","VOLUME_NUMBER","REDUNDANCY","STRIPE_COLUMNS","STRIPE_WIDTH_K","STATE","FILE_NUMBER","INCARNATION","DRL_FILE_NUMBER","RESIZE_UNIT_MB","USAGE","VOLUME_DEVICE","MOUNTPATH","CON_ID" from v$asm_volume
View Text - HTML Formatted

SELECT "GROUP_NUMBER"
, "VOLUME_NAME"
, "COMPOUND_INDEX"
, "SIZE_MB"
, "VOLUME_NUMBER"
, "REDUNDANCY"
, "STRIPE_COLUMNS"
, "STRIPE_WIDTH_K"
, "STATE"
, "FILE_NUMBER"
, "INCARNATION"
, "DRL_FILE_NUMBER"
, "RESIZE_UNIT_MB"
, "USAGE"
, "VOLUME_DEVICE"
, "MOUNTPATH"
, "CON_ID"
FROM V$ASM_VOLUME