SELECT p.addr, p.pname, b.paddr, b.name
FROM v$process p
left outer join v$bgprocess b 
  on (p.addr = b.paddr and b.paddr <>'00' and p.addr <>'00' )
/

hostgator