Oracle 数据表被锁解决方法
描述:当你操作数据表时,发现进程一直执行,大概率是数据表被已经锁住了,如下是解决思路:
1、先查看数据库被锁的表的:
select a.OS_USER_NAME, c.owner, c.object_name, b.sid, b.serial#, logon_time
from v$locked_object a, v$session b, dba_objects c
where a.session_id = b.sid and a.object_id = c.object_id
order by b.logon_time;
2、针对自己被锁的表,关闭进程:
这里的2502取值sid,26509取值serial
ALTER SYSTEM KILL SESSION '2502,26509';