GV$PROCESS

select
inst_id,                 -- INST_ID NUMBER
addr,                    -- ADDR RAW(4)
indx,                    -- PID NUMBER
ksuprpid,                -- SPID VARCHAR2(12)
ksuprunm,                -- USERNAME VARCHAR2(15)
ksuprser,                -- SERIAL# NUMBER
ksuprtid,                -- TERMINAL VARCHAR2(30)
ksuprpnm,                -- PROGRAM VARCHAR2(48)
ksuprtfi,                -- TRACEID VARCHAR2(255)
decode                   -- BACKGROUND VARCHAR2(1)
  (bitand (ksuprflg, 2), 0, null, 1),
decode                   -- LATCHWAIT VARCHAR2(8)
  (ksllawat, hextoraw ('00'), null, ksllawat),
decode                   -- LATCHSPIN VARCHAR2(8)
  (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
home |  up  |  mailbox