Cheeky Cockatoo

Life Advice and Stories, Travel, Oracle Tech, Good Food and More

sel_sess_u.sql

Download Script

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
/