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_LOCKS

8.87 V$NFS_LOCKS

V$NFS_LOCKS displays information about byte range locks held on different files by NFS clients.

Column Datatype Description

OPENSTATEID

RAW(16)

Open state ID of the open owner

OPENSEQUENCEID

NUMBER

Open Sequence ID of the open owner

LOCKSTATEID

RAW(16)

Lock state ID of the lock owner

LOCKSEQUENCEID

NUMBER

Lock sequence ID of the lock owner

LOCKOWNER

VARCHAR2(2000)

Opaque string presented as identification by the lock owner to the NFS server

OFFSET

NUMBER

Byte Offset from which lock starts

LENGTH

NUMBER

Length of the lock

LOCKTYPE

VARCHAR2(20)

Type of the lock

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