Oracle 视图 V$ASM_USERGROUP_MEMBER 官方解释,作用,如何使用详细说明
本站中文解释
Oracle视图V$ASM_USERGROUP_MEMBER用于存储ASM管理的用户组成员信息,旨在检索当前已在ASM中创建的所有用户组的成员信息,包括用户名称和用户组标识。此外,它还会显示用户组的所有密钥元素。
该视图可以使用SQL语句进行查询,语句如下:
SELECT * FROM V$ASM_USERGROUP_MEMBER;
该查询会返回ASM中所有的用户组信息,包括member_name和group_number.
官方英文解释
V$ASM_USERGROUP_MEMBER
displays the members for each Oracle Automatic Storage Management (Oracle ASM) File Access Control group.
Column | Datatype | Description |
---|---|---|
|
|
Oracle ASM disk group number |
|
|
Number of the user group member |
|
|
Incarnation number of the user group member |
|
|
User group number |
|
|
Incarnation number of the user group |
|
|
The ID of the container to which the data pertains. Possible values include:
For this view, the value is always |
Note:
In an Oracle Database instance, this view returns 0 rows when queried from a PDB.
See Also:
Oracle Automatic Storage
Management Administrator’s Guide for additional information about using views to display Oracle ASM information