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

home |  up