1. Database Reference
  2. Dynamic Performance Views
  3. Dynamic Performance (V$) Views: V$IM_COLUMN_LEVEL to V$RULE_SET_AGGREGATE_STATS
  4. V$OFS_STATS

8.98 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:

  • 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.

Note:

This view is available starting with Oracle Database 12c Release 2 (12.2.0.1).

See Also:

"V$OFSMOUNT"