GV$PROCESS definition in Oracle 8i / www.oracledba.ru
GV$PROCESS
select
inst_id, -- INST_ID NUMBER
addr, -- ADDR RAW(4)
indx, -- PID NUMBER
ksuprpid, -- SPID VARCHAR2(9)
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)
from
x$ksupr
where
bitand (ksspaflg, 1) !=0