WebDB1|/oracle/dba_script> vi lock2.sql
set linesize 200
col username for a15
col object_owner for a15
col object for a15
col lockwait for a10

select b.username username, c.sid sid, c.owner object_owner,
        c.object object, b.lockwait, a.sql_text SQL
        from v$sqltext a, v$session b, v$access c
        where a.address=b.sql_address and
        a.hash_value=b.sql_hash_value and
        b.sid = c.sid and c.owner != 'SYS';
~