This document was uploaded by user and they confirmed that they have the permission to share
it. If you are author or own the copyright of this book, please report to us by using this DMCA
report form. Report DMCA
select s.sid, s.serial#, s.username,s.osuser,s.terminal, decode(l.type,'tm','table lock','tx','row lock',null) aa, o.owner,o.object_type,o.object_name from v$session s, v$lock l,dba_objects o where s.sid=l.sid and o.object_id=l.id1 and s.username is not null order by o.object_name,s.username