select object_name, machine, s.sid, s.serial# from v$locked_object l, dba_objects o, v$session s where l.object_id = o.object_id and l.session_id = s.sid; alter system kill session '73,23375'
数据库锁表了如何用sql进行处理
最新推荐文章于 2024-07-06 08:00:00 发布
select object_name, machine, s.sid, s.serial# from v$locked_object l, dba_objects o, v$session s where l.object_id = o.object_id and l.session_id = s.sid; alter system kill session '73,23375'