Advanced Search

Kill all sessions from host in Oracle

/ Published in: PL/SQL
Save to your folder(s)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. DECLARE
  2.     host_name VARCHAR2(128) = 'hostname';
  3.  
  4.     CURSOR host_sessions IS SELECT '' || sid || '' || serial# AS session_id
  5.                 FROM v$session WHERE machine = host_name ORDER BY sid DESC;
  6. BEGIN
  7.     FOR next_row IN host_sessions
  8.     LOOP
  9.         EXECUTE IMMEDIATE 'alter system kill session :1 immediate'
  10.                            using next_row.session_id;
  11.     END LOOP;
  12. END;
  13. /

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.