kill all session of a user - Oracle Database Script. BEGIN FOR r IN (SELECT sid, serial# FROM v$session WHERE username = 'TEST_ANB') LOOP EXECUTE IMMEDIATE 'alter system kill session ''' || r.sid || ',' || r.serial# || ''''; END LOOP; END; /
BEGIN FOR r IN (SELECT sid, serial# FROM v$session WHERE username = 'TEST_ANB') LOOP EXECUTE IMMEDIATE 'alter system kill session ''' || r.sid || ',' || r.serial# || ''''; END LOOP; END; /