Monday, June 6, 2011

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

No comments:

Post a Comment