oracle 死锁处理

 select sess.sid,

       sess.serial#,

       lo.oracle_username,

       lo.os_user_name,

       ao.object_name,

       lo.locked_mode

       from v$locked_object lo,

   dba_objects ao,

   v$session sess

   where ao.object_id = lo.object_id and lo.session_id = sess.sid;

 

       SID    SERIAL# ORACLE_USERNAME

---------- ---------- ------------------------------

OS_USER_NAME

------------------------------

OBJECT_NAME

--------------------------------------------------------------------------------

LOCKED_MODE

-----------

       516      35305 HRSSC

xusm

SI_SSC_HRIT_RESIGN_APPLY

          3

 

 

SQL> alter system kill session '516,35305';

 

System altered.

 

SQL> select sess.sid,

  2     sess.serial#,

  3     lo.oracle_username,

  4     lo.os_user_name,

  5     ao.object_name,

  6     lo.locked_mode

  7     from v$locked_object lo,

  8     dba_objects ao,

  9     v$session sess

 10  where ao.object_id = lo.object_id and lo.session_id = sess.sid;

 

no rows selected

 

SQL>

查看系统id 

select spid, machine,osuser, s.program from v$session s,v$process p where s.paddr=p.addr and s.sid=3202;

 

批量kill session

ps -ef | grep LOCAL=NO | grep -v grep | awk '{print $2}' |xargs kill -9