Oracle教程 2023-02-26

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

_MEMBERS

V$ASM_USERGROUP_MEMBERS是Oracle存储管理器(ASM)信息视图，用于显示用户组之间的成员关系，包括每个成员的归属用户组信息、是否来源于ADMINISTER_DISK_GROUPS角色、添加的日期和状态。

该视图可以用于查找备份数据库中存在的ASM用户组。

使用下面的语句可以获得特定ASM用户组下所有成员信息：

SELECT USER_GROUP, MEMBER, FROM_ADMIN_ROLE, CREATED_TIME, STATE FROM V$ASM_USERGROUP_MEMBERS WHERE USER_GROUP=”;

其中 ” 指代ASM用户组的名称。

V$ASM_USERGROUP displays the creator for each Oracle Automatic Storage Management (Oracle ASM) File Access Control group.

Column	Datatype	Description
`GROUP_NUMBER`	`NUMBER`	Oracle ASM disk group number
`USERGROUP_NUMBER`	`NUMBER`	Number of the user group
`COMPOUND_INDEX`	`NUMBER`	A 32-bit number consisting of a disk group number in the high-order 8 bits and a user group number in the low-order 24 bits (for efficient access to the view)
`INCARNATION`	`NUMBER`	Incarnation number of the user group
`OWNER_NUMBER`	`NUMBER`	User group owner identified by a unique number
`OWNER_INCARNATION`	`NUMBER`	Incarnation number of the user group owner
`NAME`	`VARCHAR2(64)`	User group name
`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`.

Note:

In an Oracle Database instance, this view returns 0 rows when queried from a PDB.