Posted on Leave a comment

Oracle: Lock and Kill User Sessions

ALTER USER DBUSER ACCOUNT LOCK;

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

Leave a Reply

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