-
死锁查询
select c.session_id, b.SERIAL#, username,lockwait,status,machine,program,logon_time from
v s q l a , v sql a, v sqla,vsession b, v$locked_object c
where a.HASH_VALUE = b.sql_hash_value and b.sid = c.SESSION_ID;select sid, username, status, schemaname, osuser, process, machine, program, prev_exec_start, module, logon_time, seq#, p1text from v$session
where status = ‘ACTIVE’ and prev_exec_start is not null
order by prev_exec_start desc; -
Kill Session
alter system kill session ‘766, 54’; – c.seesion_id, b.serial#
Oracle 死锁查询与解锁
最新推荐文章于 2023-12-27 10:41:03 发布