SELECT spid, osuser, s.program FROM v$process p, v$session s WHERE p.addr=s.paddr and s.sid in (&n);

select sql_text from v$sqltext
where address = (select sql_address from v$session where paddr = (select addr from v$process where spid = &n))
order by piece;