GV$NFS_OPEN_FILES definition in Oracle Database 11.2
GV$NFS_OPEN_FILES
SELECT
inst_id, -- INST_ID NUMBER
NFSCLIENTID, -- CLIENTID NUMBER
NFSOPENOWNER, -- OPENOWNEROPAQUE VARCHAR2(2000)
NFSOPENSTATEID, -- OPENSTATEID RAW(16)
NFSOPENFILEHANDLE, -- FILEHANDLE RAW(32)
NFSOPENSEQID, -- OPENSEQUENCEID NUMBER
decode( -- OPENREAD VARCHAR2(5)
bitand(NFSOPENFLAGS,1), 0, 'FALSE', 'TRUE'),
decode( -- OPENWRITE VARCHAR2(5)
bitand(NFSOPENFLAGS,2), 0, 'FALSE', 'TRUE'),
decode( -- SHAREACCESS VARCHAR2(15)
bitand(NFSOPENFLAGS,384), 384, 'SharedReadWrite', 128, 'SharedRead', 256, 'SharedWrite'),
decode( -- SHAREDENY VARCHAR2(13)
bitand(NFSOPENFLAGS,1536), 1536, 'DenyReadWrite', 512, 'DenyRead', 1024, 'DenyWrite'),
decode( -- CONFIRMED VARCHAR2(5)
bitand(NFSOPENFLAGS,64), 0, 'FALSE', 'TRUE')
FROM
X$NFSOPENS