Wednesday, June 29, 2011

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


No comments:

Post a Comment