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;
/
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