Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

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