查询死锁并kill死锁

1.  查询死锁

SELECT'alter system kill session ''' || c.sid || '' || ',' || c.serial# ||''' ;',

   a.object_id, a.session_id, b.object_name,c.*

  FROM v$locked_object a, dba_objects b,v$session c

 WHERE a.object_id = b.object_id

   AND a.SESSION_ID = c.sid(+) AND object_nameLIKE '%ODS%'

   --AND schemaname = 'Unmi'

 ORDER BY logon_time

OR

   

SELECT'alter system DISCONNECT session ''' || c.sid || '' || ',' || c.serial# ||'''IMMEDIATE;',

       a.object_id, a.session_id,b.object_name, c.*

  FROM v$locked_object a, dba_objects b,v$session c

 WHERE a.object_id = b.object_id

   AND a.SESSION_ID = c.sid(+) AND object_nameLIKE '%ODS%'

   --AND schemaname = 'Unmi'

 ORDER BY logon_time 

2 . kill死锁

altersystem kill session '1205,4494' ;

alter systemDISCONNECT session '548,6167' IMMEDIATE;