runaway process in oracle/unix

[marist89]

select s.username, s.terminal, s.program, sa.sql_text
from v$session s, v$sql_area sa, v$process p
where s.paddr = s.addr
and a.sql_address = sa.address