Oracle教程 2023-02-24

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

V$PMEM_FILESTORE视图显示服务器中的持久内存文件存储的文件列表。它保存数据库应用程序中用作持久内存文件存储的文件的完整文件路径路径和命名属性。

可以检索V$PMEM_FILESTORE视图，从而查看应用程序正在使用的持久内存文件。

要使用V$PMEM_FILESTORE视图，需要在SQL*Plus中输入以下命令：

SELECT * FROM v$pmem_filestore;

V$PMEM_FILESTORE displays information about Persistent Memory Filestores (PMEM Filestores).

Column	Datatype	Description
`NAME`	`VARCHAR2(65)`	PMEM Filestore name
`MOUNT_POINT`	`VARCHAR2(513)`	Operating system directory path for the mount point of the PMEM Filestore
`BACKING_FILE`	`VARCHAR2(513)`	Operating system file path for the backing file of the PMEM Filestore
`BLOCK_SIZE`	`NUMBER`	Block size of the PMEM Filestore (in bytes)
`TOTAL_BYTES`	`NUMBER`	Current size of the PMEM Filestore (in bytes)
`AUTOEXTENSIBLE`	`VARCHAR2(4)`	Indicates whether the PMEM Filestore is autoextensible (`YES`) or not (`NO`)
`INCREMENT_BY`	`NUMBER`	If the PMEM Filestore is autoextensible, then this column displays the size of an autoextension increment (in bytes) If the PMEM Filestore is not autoextensible, then the value of this column is 0
`MAX_BYTES`	`NUMBER`	Maximum autoextend size (in bytes)
`AVAILABLE_BYTES`	`NUMBER`	Amount of free space currently available in the PMEM Filestore (in bytes)
`USED_BYTES`	`NUMBER`	Amount of space currently allocated to data and metadata in the PMEM Filestore (in bytes)
`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

Note:

This view is available starting with Oracle Database 21c.

分享到：