–查询被锁的会话ID
select session_id from v$locked_object;
–查询结果:SESSION_ID-------9
–查询上面会话的详细信息:
SELECT sid, serial#, username, osuser FROM v$session where sid = 9;
–查询结果:serial#------99
–将上面锁定的会话关闭:
ALTER SYSTEM KILL SESSION ‘9,99’;
–查询被锁的会话ID
select session_id from v$locked_object;
–查询结果:SESSION_ID-------9
–查询上面会话的详细信息:
SELECT sid, serial#, username, osuser FROM v$session where sid = 9;
–查询结果:serial#------99
–将上面锁定的会话关闭:
ALTER SYSTEM KILL SESSION ‘9,99’;