Re: track session activity

SELECT SID, SERIAL#,PROGRAM -- ETC
FROM V$SESSION S, V$PROCESS P
WHERE S.PADDR= P.ADDR
AND P.SPID = <the pid of threadid of the affected process>

Background processes can be listed by using v$bgprocess.

-- 
Sybrand Bakker
Senior Oracle DBA