Oracle死进程查询及解决

--查询代码

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 schemaname ='Unmi'

ORDER BY logon_time

 

--杀进程

alter system kill session '131,372';