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