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(70) 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)
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)