v$locked_object视图列出当前系统中哪些对象正被锁定
--查询被锁session_id select session_id from v$locked_object; -- SELECT sid, serial#, username, osuser FROM v$session where sid = 396; --杀掉一个会话进程 ALTER SYSTEM KILL SESSION '396,17429';
v$locked_object视图列出当前系统中哪些对象正被锁定
--查询被锁session_id select session_id from v$locked_object; -- SELECT sid, serial#, username, osuser FROM v$session where sid = 396; --杀掉一个会话进程 ALTER SYSTEM KILL SESSION '396,17429';
转载于:https://www.cnblogs.com/TSHHENLIHAI/p/10826046.html