select b.owner TABLEOWNER, b.object_name TABLENAME, c.OSUSER LOCKBY,c.USERNAME LOGINID, c.sid SID, c.SERIAL# SERIAL
from v$locked_object a,dba_objects b, v$session c
where b.object_id = a.object_id AND a.SESSION_ID =c.sid;
alter system kill session '87,36188';
87,36188 分别 指的是 sid ,serial
Oracle锁表 解决笔记
最新推荐文章于 2024-04-24 11:33:02 发布