oracle死锁的处理剖析.pdfVIP

查看有哪些表被锁住 select b.owner,b.object_name,a.session_id,a.locked_mode from v$locked_object a,dba_objects b where b.object_id = a.object_id select b.username,b.sid,b.serial#,logon_time from v$locked_object a,v$session b where a.session_id = b.sid order by b.logon_time 杀进程中的会话 alter system kill session sid,serial#; e.g alter system kill session 29,5497; 如果有 ora-00031 错误，则在后面加 immediate;alter system kill session 29,5497 immediate ； 如何杀死 oracle 死锁进程 １. 查哪个过程被锁 : 查 V$DB_OBJECT_CACHE视图 : SELECT * FROM V$DB_OBJECT_CACHE WHERE OWNER