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 |
|---|---|---|
|
|
|
Oracle ASM alias or alias directory name |
|
|
|
Owning disk group number of the alias (foreign key to the |
|
|
|
Oracle ASM file number of the alias (foreign key to the |
|
|
|
Oracle ASM file incarnation number for the alias |
|
|
|
Alias entry number for the alias |
|
|
|
Incarnation number for the parent of the alias |
|
|
|
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) |
|
|
|
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) |
|
|
|
Indicates whether the alias is to a directory ( |
|
|
|
Indicates whether the alias is system created ( |
|
|
|
The ID of the container to which the data pertains. Possible values include:
For this view, the value is always |
See Also:
Oracle Automatic Storage
Management Administrator’s Guide for additional information about using views to display Oracle ASM information
