select p.spid "Thread ID", s.sid "Session ID", 
       s.serial# "Serial No.",  b.name "Background Process", 
       substr(s.username,1,20) "User Name", substr(s.osuser,1,20) "OS User", 
       s.status "STATUS",s.program "OS Program" ,sql_text  
from v$process p, v$bgprocess b, v$session s ,v$sqlarea  
where s.paddr = p.addr 
and b.paddr(+) = p.addr
and SQL_ADDRESS=Address
and SQL_HASH_VALUE =hash_value
AND p.spid = &threadid
/