SELECT a.SESSION_ID,
c.SERIAL#,
b.object_name,
'ALTER system KILL session ''' || a.SESSION_ID || ',' || c.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;
oracle查询死锁、锁表
最新推荐文章于 2024-08-18 10:57:28 发布