Oracle教程 2023-04-02

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

本站中文解释

是一个视图，用于显示当前使用ASM时必须在ASM中设置的逻辑卷组（如：数据文件组，日志文件组）信息。此视图中列名：GROUP_NUMBER：表示逻辑卷组序号；NAME：表示逻辑卷组名；TOTAL_MB：表示逻辑卷组总容量；FREE_MB：表示逻辑卷组的空闲容量。使用方法，可以使用SQL语句查看ASM中的组详细情况：

SELECT *
FROM V$ASM_FILEGROUP;

该语句用于查看ASM中的所有逻辑卷组的详细信息，以帮助管理者进行磁盘组的管理和调整。

官方英文解释

V$ASM_FILEGROUP describes the properties of the Oracle Automatic Storage Management (Oracle ASM) File Groups.

In both Oracle ASM and Oracle Database instances, V$ASM_FILEGROUP displays one row for every File Group present in every Disk Group mounted by the Oracle ASM instance. File Groups are only displayed for Disk Groups where COMPATIBLE.ASM is set to 12.2 or higher.

Note:

There will not be an entry for the default File Group.

Column	Datatype	Description
`GROUP_NUMBER`	`NUMBER`	Number of the Disk Group in which this File Group exists (composite primary key)
`FILEGROUP_NUMBER`	`NUMBER`	Number associated to the File Group within its Disk Group (composite primary key)
`INCARNATION`	`NUMBER`	Incarnation number for the File Group (composite primary key)
`COMPOUND_INDEX`	`NUMBER`	A 32-bit number consisting of a Disk Group number in the high-order 8 bits and a File Group number in the low-order 24 bits (for efficient access to the view)
`NAME`	`VARCHAR2(128)`	Name of the File Group
`CLIENT_TYPE`	`NUMBER`	Type of client that the File Group is associated to: `DATABASE` `CLUSTER` `VOLUME`
`CLIENT_NAME`	`VARCHAR2(128)`	Name of the client (database, PDB, CDB, cluster, or volume) that the File Group is associated to
`GUID`	`VARCHAR2(32)`	If the `CLIENT_TYPE` is `DATABASE`: In a CDB environment, it is the GUID of the PDB or CDB associated with the file group, the same value as the GUID in `V$CONTAINERS`. In a non-CDB environment it is the database identifier (DBID) of the database associated with that file group. If the `CLIENT_TYPE` is `VOLUME` or `CLUSTER`, the `GUID` column is empty.
`QUOTAGROUP_NUMBER`	`NUMBER`	Number of the quota group associated with this File Group (foreign key to the `V$ASM_QUOTAGROUP` view)
`QUOTAGROUP_INCARNATION`	`NUMBER`	Incarnation number for the Quota Group
`USED_QUOTA_MB`	`NUMBER`	Used quota of the quota group in GB
`USER_NUMBER`	`NUMBER`	User number
`USER_INCARNATION`	`NUMBER`	Incarnation number of the user
`USERGROUP_NUMBER`	`NUMBER`	User group number
`USERGROUP_INCARNATION`	`NUMBER`	Incarnation number of the user group
`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

本站中文解释

官方英文解释

相关推荐