博客

select vb.name NOME, vp.program PROCESSNAME, vp.spid THREADID, vs.sid SID
  from v$session vs, v$process vp, v$bgprocess vb
 Where vb.paddr <> '00'
   and vb.paddr = vp.addr
   and vp.addr = vs.paddr;