set linesize 130
select s.username username,
a.sid sid,
a.owner||'.'||a.object object,
s.lockwait lockwait,
t.sql_text sql
from v$sqltext t,v$session s,v$access a
where t.address=s.sql_address
and t.hash_value=s.sql_hash_value
and s.sid=a.sid
and a.owner !='SYS'
and upper(substr(a.object,1,2))!='v$';