Get background process details - Oracle Database Script.
col ksbddidn
FOR a15 col ksmfsnam
FOR a20 col ksbdddsc
FOR a60
SET lines 150 pages 5000
SELECT ksbdd.ksbddidn,
ksmfsv.ksmfsnam,
ksbdd.ksbdddsc
FROM x$ksbdd ksbdd,
x$ksbdp ksbdp,
x$ksmfsv ksmfsv
WHERE ksbdd.indx = ksbdp.indx
AND ksbdp.addr = ksmfsv.ksmfsadr
ORDER BY ksbdd.ksbddidn;