–1.查询被锁定的object，及其session
select a.session_id,c.serial#,a.locked_mode,c.machine,c.terminal,b.object_name,c.logon_time
from v$locked_object a
inner join all_objects b on a.object_id=b.object_id
inner join v$session c on a.session_id=c.sid;
 
–2.查询被锁定的object，及其sql
select *
from v$sqlarea a
inner join v$session b on a.address=b.prev_sql_addr
inner join v$locked_object c on b.sid=c.session_id;
 
–3.查询锁定表的session
select *
from v$session a
inner join v$lock b on a.sid=b.sid;
 
–4.删除产生锁的session
alter system kill session ‘111,2222’ immediate;
 
视图v$lock显示当前拥有的锁以及未完成的锁的请求。
type:锁的类型
TM，表锁或DML锁
TX，行锁或事务锁
UL，用户锁
版权声明：本文为ambiguous原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://www.cnblogs.com/ambiguous/p/8384756.html