Oracle教程 2023-04-03

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

本站中文解释

Oracle视图 V$ASM_ACFSSNAPSHOTS 是Oracle Automatic Storage Management（ASM）中的一个动态查看视图，用于查看ASM实例上存储在磁盘组上的ACFS 快照。

使用V$ASM_ACFSSNAPSHOTS视图可以查看ASM实例上存储在磁盘组上的ACFS 快照，其中包括快照的用户所有权、文件系统位置、快照状态和其他信息。

例如，可以使用下面的查询来查看ASM实例上的ACFS句柄：

SELECT asm_acfs_handle FROM v$asm_acfssnapshots;

官方英文解释

V$ASM_ACFSSNAPSHOTS displays snapshot information for every mounted Oracle ACFS.

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
`SNAP_NAME`	`VARCHAR2(1024)`	Name of the snapshot
`CREATE_TIME`	`DATE`	Time when the snapshot was created
`TYPE`	`VARCHAR2(2)`	Snapshot type. Possible types are read-only (RO) or read/write (RW).
`PARENT`	`VARCHAR2(1024)`	Parent name used to create the snapshot. If the snapshot was created using the mount point as a base, parent name will be NULL. If the snapshot was created using an existing snapshot as the base, the parent name will be the name of the snapshot passed to the `acfsutil snap create -p` operation.
`LINK`	`VARCHAR2(1024)`	If link has been set, the path of the link. If unset, NULL.
`ADDITIONAL_STORAGE`	`NUMBER`	Equivalent to “storage added to snapshot” output
`QUOTA`	`NUMBER`	Value of quota. If unset, NULL.
`REPL`	`VARCHAR2(5)`	Indicates whether the snapshot is being used for replication (`TRUE`) or not (`FALSE`)
`STATE`	`VARCHAR2(14)`	The state of the snapshot: `AVAILABLE` – Default `DELETE_WAITING` – Maps to “delete waiting for last close” `DELETE_IN_PROGRESS` – Maps to “delete in progress”
`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`.

本站中文解释

官方英文解释

相关推荐