oracle死锁问题解决

1、解决表死锁问题

select b.sid,b.serial# from v$locked_object a,v$session b where a.session_id=b.sid;
ALTER SYSTEM KILL SESSION 'sid,serial#' IMMEDIATE;

2、解决定时任务（job）死锁问题

select b.sid,b.serial# from user_scheduler_running_jobs a,v$session b where a.session_id=b.sid;
ALTER SYSTEM KILL SESSION 'sid,serial#' IMMEDIATE;

3、解决存储过程死锁问题

SELECT name FROM V$DB_OBJECT_CACHE WHERE LOCKS !='0' AND owner='存储过程所属用户';
select /*+ rule*/ sid from V$ACCESS WHERE object='存储过程名';--上面查到的name
SELECT sid,serial# FROM V$SESSION WHERE sid = 上面查到的sid;
ALTER SYSTEM KILL SESSION 'sid,serial#' IMMEDIATE;