set linesize 132
set pagesize 80
col username format a15
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 like upper('%&username%')
and s.sql_address=a.address
/
