select
  inst_id,                                 -- INST_ID NUMBER
  ksusenum,                                -- SID NUMBER
  ksuseser,                                -- SERIAL# NUMBER
  decode(                                  -- AUTHENTICATION_TYPE VARCHAR2(26)
    ksuseaty, 0, 'DATABASE', 1, 'OS', 2, 'NETWORK', 3, 'PROXY', 4, 'SERVER', 5, 'PASSWORD', 6, 'EXTERNAL ADAPTERS', 7, 'INTERNAL', 8, 'GLOBAL', 9, 'EXTERNAL', 10, 'PASSWORD BASED GLOBAL USER', '?'),
  ksuseunm,                                -- OSUSER VARCHAR2(30)
  ksuseban,                                -- NETWORK_SERVICE_BANNER VARCHAR2(4000)
  decode(                                  -- CLIENT_CHARSET VARCHAR2(40)
    ksusecsid,0,'Unknown',nls_charset_name(ksusecsid)),
  decode(                                  -- CLIENT_CONNECTION VARCHAR2(13)
    bitand(ksuseflags,1), 0, 'Heterogeneous', 'Homogeneous'),
  decode(                                  -- CLIENT_OCI_LIBRARY VARCHAR2(27)
    ksusecllib,1,'Home-based',2,'Full Instant Client', 3,'XE Instant Client',4,'Light Weight Instant Client', 5,'OCI','Unknown'),
  SYS_OP_VERSION(ksuseclvsn),              -- CLIENT_VERSION VARCHAR2(40)
  ksusecldrv,                              -- CLIENT_DRIVER VARCHAR2(9)
  decode(                                  -- CLIENT_LOBATTR VARCHAR2(23)
    bitand(ksusecllbf,1), 1, 'Client Temp Lob Rfc On', 'Client Temp Lob Rfc Off'),
  ksuseclregid                             -- CLIENT_REGID NUMBER
from
  x$ksusecon
where
  bitand(ksuseflg,1)!=0 and bitand(ksuseflg,16)=0