TX LOCKS

set lines 180
break on sid on sql_hash_value on request on lmode

select /*+ RULE */ a.sid, a.sql_hash_value, c.lmode,c.request, b.sql_text
from v$session a, v$sqltext b,v$lock c
where a.sql_hash_value = b.hash_value
and a.sql_address = b.address
and a.sid=c.sid and c.type='TX' and c.request>0
order by sid,hash_value,address,piece
/
--Just line
select /*+ RULE */ a.sid, a.sql_hash_value, c.lmode,c.request, b.sql_text
from v$session a, v$sqltext b,v$lock c
where a.sql_hash_value = b.hash_value
and a.sql_address = b.address
and a.sid=c.sid and c.type='TX' and c.block>0
order by sid,hash_value,address,piece
/