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 AI Database 26ai.