sel_sess.sql
Download Script
set linesize 132
set pagesize 80
col username format a12
col sql_text format a50
select sid, serial#, username, sql_address, sql_text
from v$session s, v$sqlarea a
where username is not null
and username not in ('SYS','DBSNMP','SYSTEM')
and s.sql_address=a.address
/
set linesize 124