GV$BGPROCESS
select p.inst_id, -- INST_ID NUMBER p.ksbdppro, -- PADDR RAW(4) p.ksbdpser, -- PSERIAL# NUMBER p.ksbdpnam, -- NAME VARCHAR2(5) d.ksbdddsc, -- DESCRIPTION VARCHAR2(64) p.ksbdperr -- ERROR NUMBER from x$ksbdp p, x$ksbdd d where p.indx=d.indx and p.ksbdpnam not like 'TEST%'

home |  up  |  mailbox