Oracle教程 2023-02-24

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

：

Oracle V$DNFS_STATS视图显示有关Oracle数据库文件系统的统计信息。

这个视图可以用来监控Oracle数据库文件系统的性能，可以帮助我们检测数据文件系统中可能存在的性能瓶颈。通过此视图，我们可以获取诸如文件系统I/O数量、访问时间和服务器上的缓存访问等信息，以及有关缓存页面的统计数据。

要使用Oracle V$DNFS_STATS视图，我们必须在此视图之前安装Oracle软件并创建数据库文件系统。然后，我们可以使用此视图查询数据库文件系统的统计信息。

V$DNFS_STATS displays information about the Oracle process NFS operation statistics issued by Direct NFS.

Column	Datatype	Description
`PNUM`	`NUMBER`	Oracle process number that statistics are relevant to
`NFS_NULL`	`NUMBER`	Null
`NFS_GETATTR`	`NUMBER`	Get attributes
`NFS_SETATTR`	`NUMBER`	Set attributes
`NFS_LOOKUP`	`NUMBER`	Lookup object
`NFS_ACCESS`	`NUMBER`	Access object
`NFS_READLINK`	`NUMBER`	Read link
`NFS_READ`	`NUMBER`	Read file
`NFS_WRITE`	`NUMBER`	Write file
`NFS_CREATE`	`NUMBER`	Create file
`NFS_MKDIR`	`NUMBER`	Make directory
`NFS_SYMLINK`	`NUMBER`	Symbolic link
`NFS_MKNOD`	`NUMBER`	Make node
`NFS_REMOVE`	`NUMBER`	Remove file
`NFS_RMDIR`	`NUMBER`	Remove directory
`NFS_RENAME`	`NUMBER`	Rename
`NFS_LINK`	`NUMBER`	Link
`NFS_READDIR`	`NUMBER`	Read directory
`NFS_READDIRPLUS`	`NUMBER`	Read directory plus
`NFS_FSSTAT`	`NUMBER`	File system status
`NFS_FSINFO`	`NUMBER`	File system information
`NFS_PATHCONF`	`NUMBER`	Path configuration
`NFS_COMMIT`	`NUMBER`	Commit
`NFS_MOUNT`	`NUMBER`	Mount
`NFS_READBYTES`	`NUMBER`	Number of bytes read from NFS server
`NFS_WRITEBYTES`	`NUMBER`	Number of bytes written to NFS server
`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

分享到：