Oracle死锁处理

2021-11-19 15:05:27

SELECT s.username,l.OBJECT_ID,l.SESSION_ID,s.SERIAL#,
l.ORACLE_USERNAME,l.OS_USER_NAME,l.PROCESS,b.OBJECT_NAME,p.spid
FROM V$LOCKED_OBJECT l,V$SESSION S,dba_objects b,v$process p
WHERE l.SESSION_ID=S.SID and b.object_id=l.object_id and S.PADDR=p.ADDR and b.object_name=‘AAA‘

1.alter system kill session ‘sid,serial#‘;