2021-03-23

oracle 表锁了怎么办

1、查出锁表的sid和serial

select sess.sid,

sess.serial#, 

lo.oracle_username, 

lo.os_user_name, 

ao.object_name, 

lo.locked_mode 

from v$locked_object lo, 

dba_objects ao, 

v$session sess 

where ao.object_id = lo.object_id and lo.session_id = sess.sid;

2、kill掉，两个参数，第一个参数上面sql查出的sid，第二个serial
alter system kill session ‘771,11001’;