GV$PX_SESSTAT definition in Oracle 9i / www.oracledba.ru
GV$PX_SESSTAT
select
a.inst_id, -- INST_ID NUMBER
a.addr, -- SADDR RAW(4)
a.indx, -- SID NUMBER
a.ksuseser, -- SERIAL# NUMBER
decode -- QCSID NUMBER
(b.kxfpdpqcsid, NULL, a.indx, b.kxfpdpqcsid),
b.kxfpdpqcser, -- QCSERIAL# NUMBER
b.kxfpdpcin, -- QCINST_ID NUMBER
b.kxfpdpsvgrp, -- SERVER_GROUP NUMBER
b.kxfpdpsvset, -- SERVER_SET NUMBER
b.kxfpdpsvnum, -- SERVER# NUMBER
b.kxfpdpadg, -- DEGREE NUMBER
b.kxfpdprdg, -- REQ_DEGREE NUMBER
c.ksusestn, -- STATISTIC# NUMBER
c.ksusestv -- VALUE NUMBER
from
x$ksuse a,
x$kxfpdp b,
x$ksusesta c
where
bitand (a.ksspaflg, 1) !=0 and bitand (a.ksuseflg, 1) !=0 and a.KSUSEQCSID > 0 and a.ksusepro = b.kxfpdppro (+) and a.indx = c.indx and c.ksusestn < (
select
ksusgstl
from
x$ksusgif)