DBA Data[Home] [Help]

VIEW: SYS.GV_$ASM_ALIAS

Source

View Text - Preformatted

SELECT "INST_ID","NAME","GROUP_NUMBER","FILE_NUMBER","FILE_INCARNATION","ALIAS_INDEX","ALIAS_INCARNATION","PARENT_INDEX","REFERENCE_INDEX","ALIAS_DIRECTORY","SYSTEM_CREATED","CON_ID" FROM gv$asm_alias
View Text - HTML Formatted

SELECT "INST_ID"
, "NAME"
, "GROUP_NUMBER"
, "FILE_NUMBER"
, "FILE_INCARNATION"
, "ALIAS_INDEX"
, "ALIAS_INCARNATION"
, "PARENT_INDEX"
, "REFERENCE_INDEX"
, "ALIAS_DIRECTORY"
, "SYSTEM_CREATED"
, "CON_ID"
FROM GV$ASM_ALIAS