oracle死锁的处理.docVIP

查看有哪些表被锁住 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=过程的所属用户 AND CLOCKS!=0; 2. 查是哪一个SID,通过SID可知道是哪个SESSION: V$ACCESS视图: SELECT * FRO