Posted on Leave a comment

Lock and Kill User Connections


ALTER USER APPLICATION_USER ACCOUNT LOCK;

SELECT ‘alter system kill session ”’ || sid
|| ‘,’ || serial# || ”’; ‘ || sql_id death
FROM v$session
WHERE username = ‘APPLICATION_USER’;

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.