select
  inst_id,                                 -- INST_ID NUMBER
  addr,                                    -- ADDR RAW(8)
  indx,                                    -- PID NUMBER
  ksuprpid,                                -- SPID VARCHAR2(24)
  ksuprpname,                              -- PNAME VARCHAR2(5)
  ksuprunm,                                -- USERNAME VARCHAR2(15)
  ksuprser,                                -- SERIAL# NUMBER
  ksuprtid,                                -- TERMINAL VARCHAR2(16)
  ksuprpnm,                                -- PROGRAM VARCHAR2(64)
  ksuprtfi,                                -- TRACEID VARCHAR2(255)
  ksuprtfn,                                -- TRACEFILE VARCHAR2(513)
  decode(                                  -- BACKGROUND VARCHAR2(1)
    bitand(ksuprflg,2),0,null,1),
  decode(                                  -- LATCHWAIT VARCHAR2(16)
    ksllawat,hextoraw('00'),null,ksllawat),
  decode(                                  -- LATCHSPIN VARCHAR2(16)
    ksllaspn,hextoraw('00'),null,ksllaspn),
  ksuprpum,                                -- PGA_USED_MEM NUMBER
  ksuprpnam+ksuprpram,                     -- PGA_ALLOC_MEM NUMBER
  ksuprpfm,                                -- PGA_FREEABLE_MEM NUMBER
  case                                     -- PGA_MAX_MEM NUMBER 
     when ksuprpnam+ksuprpram > ksuprpmm 
     then ksuprpnam+ksuprpram 
     else ksuprpmm end 
from
  x$ksupr
where
  bitand(ksspaflg,1)!=0