The following rudimentary script will show you the basics. You can expand on this to show what you need.

select b.sid, b.username, a.sql_text
from v$sqlarea a,
v$session b
where a.address=b.sql_address

Oracle’s Enterprise Manager ‘Top Sessions’, ‘Top SQL’ provides a good gui interface.