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' ) /