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)

home |  up  |  mailbox