Tuesday, January 28, 2014

Kill sesion using script in rac database

BEGIN
  FOR r IN (select sid,serial#,inst_id from gv$session where username = 'user')
  LOOP
    EXECUTE IMMEDIATE 'alter system kill session ''' || r.sid || ',' || r.serial# ||',@' ||r.inst_id|| '''immediate';
  END LOOP;
END;
/

No comments:

Post a Comment