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_THREADS

9.102 V$OFS_THREADS

V$OFS_THREADS displays information about Oracle file system (OFS) threads.

Column Datatype Description

PDBID

NUMBER

ID of the PDB in which the thread was created

FSID

NUMBER

ID of the mounted file system on which the thread is working

FSNAME

VARCHAR2(1024)

Name of the mounted file system on which the thread is working

FILE_NAME

VARCHAR2(1024)

File, directory, or filesystem on which the thread is working

The value of this column depends on the value of the REQ_TYPE column:

  • If REQ_TYPE = SYSREQ, this column displays the path to the mount point of the filesystem on which the thread is working.

  • If REQ_TYPE = FILEREQ, this column displays the name of the file or directory on which the thread is working.

  • If REQ_TYPE = NONE, the value of this column is null.

THREADID

VARCHAR2(24)

ID of the thread

THREAD_TYPE

VARCHAR2(24)

Type of thread:

  • WORKER - The thread is used for executing file, directory, or filesystem requests.

  • RECEIVER - The thread receives requests from all OFS mounted file systems.

THREAD_NAME

VARCHAR2(24)

Name of the thread

REQ_TYPE

VARCHAR2(1024)

Type of request:

  • SYSREQ

  • FILEREQ

  • NONE

OPCODE

VARCHAR2(1024)

Type of operation on which the thread is working

The value of this column depends on the value of the REQ_TYPE column:

  • If REQ_TYPE = SYSREQ, this column displays a DBMS_FS operation.

  • If REQ_TYPE = FILEREQ, this column displays any type of file operation.

  • If REQ_TYPE = NONE, the value of this column is null.

ELAPSED_TIME_MICRO

NUMBER

If REQ_TYPE = SYSREQ, the amount of time (in microseconds) that has elapsed since the current request was queued

SYSRQ_COUNT

NUMBER

Total number of REQ_TYPE = SYSREQ requests completed since the instance was started

FREQ_COUNT

NUMBER

Total number of REQ_TYPE = FILEREQ requests completed since the instance was started

WAIT_EVENT

VARCHAR2(64)

Event on which the thread is waiting

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 view is available starting with Oracle Database 23ai.