V$NFS_CLIENTS definition in Oracle Database 11.2
V$NFS_CLIENTS

SELECT
  NFSCLIENTID,                             -- CLIENTID NUMBER
  NFSPRINCIPAL,                            -- PRINCIPAL VARCHAR2(2000)
  NFSOPAQUECLIENT,                         -- CLIENTOPAQUEIDENTIFIER VARCHAR2(1000)
  NFSVERIFIER,                             -- VERIFIER RAW(8)
  NFSLEASEEXPIRY,                          -- LEASEEXPIRY NUMBER
  NFSCLIENTNETID || NFSCLIENTADDR,         -- CLIENTADDR VARCHAR2(2000)
  decode(                                  -- CONFIRMED VARCHAR2(5)
    bitand(NFSFLAGS,1), 1, 'TRUE', 'FALSE') 
FROM
  X$NFSCLIENTS
home |  up