1.查询被锁的会话ID:
SELECT a.object_id, a.session_id, b.object_name, c.*
FROM v$locked_object a, dba_objects b, v$session c
WHERE a.object_id = b.object_id
查询结果:SESSION_ID-------9
2.查询上面会话的详细信息:
SELECT sid, serial#, username, osuser FROM v$session where sid = 9;
3.将上面锁定的会话关闭:
ALTER SYSTEM KILL SESSION '9,99'; (sid,serial)
AND a.SESSION_ID = c.sid(+) ;
执行结果:
4.锁定的会话关闭成功之后对之前的表就可以执行想要的操作了。