oracle查询死锁并是删除

247 阅读1分钟

select s.username,s.sid,s.serial#,s.logon_time--,s.* from vlockedobjectl,vlocked_object l,vsession s where l.session_id=s.sid order by s.logon_time; -- 1 BUTDWP 5197 44083 2023/6/5 12:20:10

alter system kill session '5197,24845';