V$OFS_STATS
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:
|
Note: This database view is supported only on the Linux operating system.
See Also: “V$OFSMOUNT”