Oracle教程 2023-02-24

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

Oracle数据库中，V$ASM_ACFSVOLUMES视图保存了ASM-ACFS卷的信息，主要包括：

·VOLUME_NAME：ACFS卷的名称；
·SIZE：ACFS卷的大小；
·SECTOR_SIZE：ACFS卷的扇区大小；
·ACFS_VERSION：ACFS卷的格式版本；
·ENCRYPTION：加密的状态；
·STATUS：该卷的状态；
·FS_UUID：ACFS文件系统的UUID。

通过此视图，用户可以查询Oracle ASM-ACFS卷的当前状态，主要应用于性能监测、确定问题的定位和连接状态等等。

使用V$ASM_ACFSVOLUMES视图，可以通过如下SQL语句实现：

SELECT VOLUME_NAME,SIZE,SECTOR_SIZE,ACFS_VERSION,ENCRYPTION,STATUS,FS_UUID FROM V$ASM_ACFSVOLUMES;

V$ASM_ACFSVOLUMES displays information about mounted Oracle ACFS volumes, correlated with V$ASM_FILESYSTEM.

Column	Datatype	Description
`FS_NAME`	`VARCHAR2(1024)`	File system mount point (foreign key to `V$ASM_FILESYSTEM`)
`VOL_DEVICE`	`VARCHAR2(256)`	Name of the Oracle ADVM device
`VOL_LABEL`	`VARCHAR2(64)`	Volume label (optional name) assigned through `mkfs`/`acfsformat`; NULL if no name exists
`PRIMARY_VOL`	`VARCHAR2(5)`	Indicates whether the volume is the primary volume for the file system (`TRUE`) or not (`FALSE`)
`TOTAL_MB`	`NUMBER`	Size of the volume device (in megabytes)
`FREE_MB`	`NUMBER`	Available space on the volume device (in megabytes)
`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`.