V$ASM_ALIAS

7.48 V$ASM_ALIAS

In an Oracle Automatic Storage Management (Oracle ASM) instance, V$ASM_ALIAS displays one row for every alias present in every disk group mounted by the Oracle ASM instance.

Column	Datatype	Description
`NAME`	`VARCHAR2(70)`	Oracle ASM 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`	Oracle ASM file number of the alias (foreign key to the `V$ASM_FILE` view)
`FILE_INCARNATION`	`NUMBER`	Oracle ASM 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)
`ALIAS_DIRECTORY`	`VARCHAR2(1)`	Indicates whether the alias is to a directory (`Y`) or to an Oracle ASM file (`N`)
`SYSTEM_CREATED`	`VARCHAR2(1)`	Indicates whether the alias is system created (`Y`) or user created (`N`)
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data For this view, the value is always `0`.