Oracle教程 2023-02-24

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

本站中文解释

Oracle视图V$OFS_STATS存储着Oracle文件系统（OFS）的统计信息。它提供了目录，文件和段的状态数据，可以帮助开发人员识别性能功能和问题。

用途：

1. 该视图可用于监视和跟踪Oracle文件系统的吞吐量和性能指标，以便更好地优化系统性能。

2. 它还可以帮助分析OFS相关事件并定位可能出现的故障，从而节省排查时间。

使用：

可以通过查询 V$OFS_STATS 来检索特定OFS统计数据，可通过以下SQL查询语句获取：

SELECT * FROM V$OFS_STATS;

此外，也可以连接其他活动视图（如V$ACTIVE_SESSIONS）以获取更多信息：

SELECT S.*, OFS.*
FROM OVS$OFS_STATS OFS
JOIN V$ACTIVE_SESSIONS S
ON OFS.SID = S.SID;

官方英文解释

V$OFS_STATS displays performance statistics for various Oracle File System operations. These statistics are maintained at per mount level.

Column	Datatype	Description
`OFS_MNTPNT`	`VARCHAR2(4096)`	Mount point
`OFS_LOOKUP`	`NUMBER`	Number of lookup operations performed
`OFS_FORGET`	`NUMBER`	Number of forget operations performed
`OFS_GETATTR`	`NUMBER`	Number of getattr operations
`OFS_SETATTR`	`NUMBER`	Number of setattr operations
`OFS_READLINK`	`NUMBER`	Number of readlink operations
`OFS_SYMLINK`	`NUMBER`	Number of symlink operations
`OFS_MKNOD`	`NUMBER`	Number of mknod operations
`OFS_MKDIR`	`NUMBER`	Number of mkdir operations
`OFS_UNLINK`	`NUMBER`	Number of remove file operations
`OFS_RMDIR`	`NUMBER`	Number of remove directory operations
`OFS_RENAME`	`NUMBER`	Number of file rename operations
`OFS_LINK`	`NUMBER`	Number of hard link operations
`OFS_OPEN`	`NUMBER`	Number of file open operations
`OFS_READ`	`NUMBER`	Number of file read operations
`OFS_WRITE`	`NUMBER`	Number of file write operations
`OFS_STATFS`	`NUMBER`	Number of statfs operations performed
`OFS_RELEASE`	`NUMBER`	Number of release operations
`OFS_FSYNC`	`NUMBER`	Number of file sync operations
`OFS_SETXATTR`	`NUMBER`	Number of set extended attributes operations
`OFS_GETXATTR`	`NUMBER`	Number of get extended attributes
`OFS_LISTXATTR`	`NUMBER`	Number of list extended attributes
`OFS_REMOVEXATTR`	`NUMBER`	Number of remove extended attributes
`OFS_FLUSH`	`NUMBER`	Number of flush operations
`OFS_INIT`	`NUMBER`	Number of init operations
`OFS_OPENDIR`	`NUMBER`	Number of opendir operations
`OFS_READDIR`	`NUMBER`	Number of readdir operations
`OFS_RELEASEDIR`	`NUMBER`	Number of releasedir operations
`OFS_FSYNCDIR`	`NUMBER`	Number of directory sync operations
`OFS_GETLK`	`NUMBER`	Number of file get lock operations
`OFS_SETLK`	`NUMBER`	Number of file lock operations
`OFS_SETLKW`	`NUMBER`	Number of file lock operation with wait option
`OFS_ACCESS`	`NUMBER`	Number of access operations
`OFS_CREATE`	`NUMBER`	Number of create operations
`OFS_INTERRUPT`	`NUMBER`	Number of interrupt operations received on the mount
`OFS_BMAP`	`NUMBER`	Number of block map operations received
`OFS_DESTROY`	`NUMBER`	Number of destroy operations
`OFS_BYTES_READ`	`NUMBER`	Total number of bytes read on the mount point
`OFS_BYTES_WRITTEN`	`NUMBER`	Total number of bytes written to the mount point
`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 database view is supported only on the Linux operating system.

本站中文解释

官方英文解释

相关推荐