Oracle教程 2023-02-24

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

Oracle视图V$NFS_OPEN_FILES用于显示NFS文件系统中所有打开文件的信息。Oracle 11gR2及以后版本使用V$NFS_OPEN_FILES视图。

该视图包含下列字段：

FILE_NAME：指向NFS文件系统中打开文件的完整路径。
FID：文件系统中该文件的ID。
DEVICE_NUM：文件系统在实例中关联的设备号。
BLOCKSIZE：指定文件系统的块大小。
TYPE：打开文件的类型。

要使用V$NFS_OPEN_FILES视图，请执行select * from V$NFS_OPEN_FILES语句。或者您可以根据某些搜索值显示仅感兴趣的行，如：

SELECT * FROM V$NFS_OPEN_FILES WHERE file_name like ‘/u01/oradata/%’;

V$NFS_OPEN_FILES displays information about all the files currently opened by clients at the NFS server.

Column	Datatype	Description
`CLIENTID`	`NUMBER`	Number identifying the client
`OPENOWNEROPAQUE`	`VARCHAR2(2000)`	All the files currently opened by clients at the NFS server
`OPENSTATEID`	`RAW(16)`	Open state ID of the open owner
`FILEHANDLE`	`RAW(32)`	FileHandle of the file that has been opened
`OPENSEQUENCEID`	`NUMBER`	Open sequence ID of open owner
`OPENREAD`	`VARCHAR2(5)`	`TRUE` if the file is open for READ operations; otherwise `FALSE`
`OPENWRITE`	`VARCHAR2(5)`	`TRUE` if the file is open for WRITE operations; otherwise `FALSE`
`SHAREACCESS`	`VARCHAR2(15)`	Sharing mode of the file (SharedReadWrite, SharedRead, SharedWrite)
`SHAREDENY`	`VARCHAR2(13)`	Deny mode of the file (DenyReadWrite, DenyRead, DenyWrite)
`CONFIRMED`	`VARCHAR2(5)`	`TRUE` if open is confirmed; otherwise `FALSE`
`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

分享到：