Oracle 视图 V$ASM_ALIAS 官方解释，作用，如何使用详细说明

本站中文解释

Oracle 视图V$ASM_ALIAS是V$数据库中的一个内部视图，主要显示系统中所有存储配置的别名，以及它们的对应关系。

1. 用途：用V$ASM_ALIAS视图可以了解在存储管理系统中设置了哪些别名，以及它们之间的关联。

2. 使用方法：可以在SQL*Plus中使用SELECT语句来查询V$ASM_ALIAS视图中的数据。例如，可以使用以下SELECT语句来查询存储系统中某个别名的实际存储路径：

SELECT STORAGE_PATH FROM V$ASM_ALIAS WHERE ALIAS_NAME=’Alias_Name’;

官方英文解释

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