select
  w.inst_id,                               -- INST_ID NUMBER
  w.kywmnfnum,                             -- SESSION_ID NUMBER
  w.kywmnfpc,                              -- PERFORMANCE_CLASS VARCHAR2(32)
  w.kywmnfwrc,                             -- WORK_REQUEST_CLASS VARCHAR2(32)
  decode(                                  -- HOP_COUNT NUMBER
    bitand(w.kywmnfflg,1), 0, 0, 1),
  decode(                                  -- PC_UNKNOWN NUMBER
    bitand(w.kywmnfflg,2), 0, 0, 1),
  s.service_name,                          -- SERVICE_NAME VARCHAR2(64)
  s.module,                                -- MODULE VARCHAR2(48)
  s.action,                                -- ACTION VARCHAR2(32)
  s.username,                              -- USERNAME VARCHAR2(30)
  s.program                                -- PROGRAM VARCHAR2(64)
from
  x$kywmnf w,
  v$session s
where
  w.kywmnfnum = s.sid