Oracle教程 2023-02-24

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

本站中文解释

动态视图

Oracle中V$ASM_FILEGROUP_PROPERTY动态视图是一个存储在内存中的表，提供了ASM文件组属性数据，可以用来查看ASM文件组的状态，相关属性，以及文件组信息。它对于管理ASM文件组非常实用。

V$ASM_FILEGROUP_PROPERTY动态视图的字段说明如下：

GROUP_NUMBER： ASM文件组标识号；
NAME：ASM文件组名称；
GROUPDESC： ASM文件组描述；
STATUS：ASM文件组状态；
ALLOCCAP：ASM文件组伸缩容量；
COMPATIBILITY：ASM文件组兼容性模式；
HOMECOUNT：文件组主目录数量；
Path：ASM文件组路径；
FORMAT：ASM文件组块格式。

使用V$ASM_FILEGROUP_PROPERTY动态视图的方法一般是使用SQL语句进行查询，例如：

SELECT * FROM V$ASM_FILEGROUP_PROPERTY;

该语句用于查询ASM文件总群的信息数据。

官方英文解释

V$ASM_FILEGROUP_PROPERTY describes all the properties of every Oracle Automatic Storage Management (Oracle ASM) File Group.

In both Oracle ASM and Oracle Database instances, V$ASM_FILEGROUP_PROPERTY will display one row for every property of every file type of every File Group contained in every Disk Group mounted by the instance.

File Group properties are only displayed for File Groups on 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)
`COMPOUND_INDEX`	`NUMBER`	A 32-bit number consisting of a Disk Group number in the high-order 8 bits and a Property Number in the low-order 24 bits (for efficient access to the view)
`PROPERTY_INDEX`	`NUMBER`	Number of this property in the Disk Group for the File Group (composite primary key)
`INCARNATION`	`NUMBER`	Incarnation number for this property (composite primary key)
`FILE_TYPE`	`VARCHAR2(30)`	Type of file the property will be applied to: `ARCHIVELOG` `ASMPARAMETERFILE` `ASMVDRL` `ASMVOL` `AUDIT_SPILLFILES` `AUTOBACKUP` `BACKUPSET` `CHANGETRACKING` `CONTAINER` `CONTROLFILE` `DATAFILE` `DATAGUARDCONFIG` `DUMPSET` `FLASHBACK` `FLASHFILE` `KEY_STORE` `OCRBACKUP` `OCRFILE` `ONLINELOG` `PARAMETERFILE` `TEMPFILE` `VOTINGFILE` `XTRANSPORT` The value can be `NULL` for properties with a File Group granularity.
`NAME`	`VARCHAR2(64)`	Full name of the property. Possible values: `COMPATIBLE.CLIENT` `DBCLONE_STATUS` `OWNER` `PARENT_FILEGROUP_NUMBER` `POWER_LIMIT` `PRIORITY` `REDUNDANCY` `STRIPING` `USER_GROUP`
`VALUE`	`VARCHAR2(256)`	Value of the property See Oracle Automatic Storage Management Administrator’s Guide for information about file group property values.
`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

本站中文解释

官方英文解释

相关推荐