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