Oracle教程 2023-04-08

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

Oracle视图V$ASM_USER是一个今天数据字典视图，具有以下每个列：

USER_NUMBER：给定存储管理用户的编号。

USER_NAME：给定存储管理用户的名称。

USER_TYPE：指定存储管理用户类型。

V$ASM_USER视图用于显示和管理所支持的存储管理用户。它可以帮助DBA了解已经创建的存储管理用户名称、类型和编号等信息。要查看V$ASM_USER视图的内容，可以使用以下SQL查询：

SELECT *
FROM V$ASM_USER;

V$ASM_USER displays the effective operating system user names of connected database instances and of file owners.

Column	Datatype	Description
`GROUP_NUMBER`	`NUMBER`	Oracle ASM disk group number
`USER_NUMBER`	`NUMBER`	Oracle ASM internal unique user number
`COMPOUND_INDEX`	`NUMBER`	A 32-bit number consisting of a disk group number in the high-order 8 bits and a user number in the low-order 24 bits (for efficient access to the view)
`INCARNATION`	`NUMBER`	Incarnation number of the user
`CLUSTER_ID`	`VARCHAR2(128)`	Oracle ASM cluster ID. The `CLUSTER_ID` and `OS_NAME` pair can be used to uniquely identify a user.
`OS_ID`	`VARCHAR2(128)`	Operating system user ID
`OS_NAME`	`VARCHAR2(33)`	Operating system user 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.