sqlforge
We've moved to http://sqlforge.us/blog/
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
‹
›
Home
View web version
No comments:
Post a Comment