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). |
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) |