Oracle锁

如何查看oracle的锁是sql语句引起的

 

1、查看引起锁的session_id

 

select * from v$locked_object --where os_user_name='sync4j'

 

 

2、找到引起的sql语句
SELECT a.username,
a.machine,
a.program,
a.sid,
a.serial#,
a.status,
c.piece,
c.sql_text
FROM v$session a,
v$sqltext c
WHERE a.sid = 139
and a.sql_address=c.address(+)
ORDER BY c.piece

v$sqltext就是引起锁的sql语句了