Oracle批量kill session



SELECT 'alter system kill session '''||SID || ',' || SERIAL#||''';' 
  FROM V$SESSION 
 WHERE SID in 
       (SELECT SESSION_ID 
          FROM V$LOCKED_OBJECT, USER_OBJECTS 
         WHERE V$LOCKED_OBJECT.OBJECT_ID = USER_OBJECTS.OBJECT_ID);
 
 
请使用浏览器的分享功能分享到微信等