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

8.88 V$NFS_OPEN_FILES

V$NFS_OPEN_FILES displays information about all the files currently opened by clients at the NFS server.

Column Datatype Description

CLIENTID

NUMBER

Number identifying the client

OPENOWNEROPAQUE

VARCHAR2(2000)

All the files currently opened by clients at the NFS server

OPENSTATEID

RAW(16)

Open state ID of the open owner

FILEHANDLE

RAW(32)

FileHandle of the file that has been opened

OPENSEQUENCEID

NUMBER

Open sequence ID of open owner

OPENREAD

VARCHAR2(5)

TRUE if the file is open for READ operations; otherwise FALSE

OPENWRITE

VARCHAR2(5)

TRUE if the file is open for WRITE operations; otherwise FALSE

SHAREACCESS

VARCHAR2(15)

Sharing mode of the file (SharedReadWrite, SharedRead, SharedWrite)

SHAREDENY

VARCHAR2(13)

Deny mode of the file (DenyReadWrite, DenyRead, DenyWrite)

CONFIRMED

VARCHAR2(5)

TRUE if open is confirmed; otherwise FALSE

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