../E40402-16.epub /> ../E40402-16.mobi />

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