Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-10
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
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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)