V$ASM_ALIAS

In an Automatic Storage Management instance, V$ASM_ALIAS displays one row for every alias present in every disk group mounted by the Automatic Storage Management instance. In a database instance, V$ASM_ALIAS displays no rows.

Column	Datatype	Description
`NAME`	`VARCHAR2(48)`	Automatic Storage Management alias or alias directory name
`GROUP_NUMBER`	`NUMBER`	Owning disk group number of the alias (foreign key to the `V$ASM_DISKGROUP` view)
`FILE_NUMBER`	`NUMBER`	Automatic Storage Management file number of the alias (foreign key to the `V$ASM_FILE` view)
`FILE_INCARNATION`	`NUMBER`	Automatic Storage Management file incarnation number for the alias
`ALIAS_INDEX`	`NUMBER`	Alias entry number for the alias
`ALIAS_INCARNATION`	`NUMBER`	Incarnation number for the parent of the alias
`PARENT_INDEX`	`NUMBER`	A 32-bit number consisting of a disk group number in the high-order 8 bits and an alias entry number in the low-order 24 bits (number of the directory containing the alias)
`REFERENCE_INDEX`	`NUMBER`	A 32-bit number consisting of a disk group number in the high-order 8 bits and an alias entry number in the low-order 24 bits (number of the directory describing the current entry). For alias entries, the `REFERENCE_INDEX` is set to `0`.
`ALIAS_DIRECTORY`	`VARCHAR2(1)`	Indicates whether the alias is to a directory (`Y`) or to an Automatic Storage Management file (`N`)
`SYSTEM_CREATED`	`VARCHAR2(1)`	Indicates whether the alias is system created (`Y`) or user created (`N`)