select vb.name NAME, 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;

select p.spid "Thread ID",
b.name "Background Process",
s.username "User Name",
s.osuser "OS User",
s.status "STATUS",
s.sid "Session ID",
s.serial# "Serial No.",
s.program "OS Program"
from v$process p, v$bgprocess b, v$session s
where s.paddr = p.addr and b.paddr(+) = p.addr; 

thiru@9.2.0:SQL>select s.sid,s.serial#,s.username,s.program,s.machine,t.sql_text
  2  from v$session s,v$sql t where s.sql_address=t.address and s.sql_hash_value=t.hash_value
  3  and s.type='USER'
  4  order by
  5  t.cpu_time desc;