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.
Discuss This Question: 1  Reply