DBA Hub

📋Steps in this guide1/1

kill all session of a user

BEGIN FOR r IN (select sid,serial# from v$session where username = 'TEST_ANB') LOOP EXECUTE IMMEDIATE 'alter system kill session ''' || r.sid || ',' || r.serial# || ''''; END LOOP; END; /

oracle configurationintermediate
by OracleDba
13 views
1

kill all session of a user

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
BEGIN
FOR r IN (select sid,serial# from v$session where username = 'TEST_ANB')
LOOP
EXECUTE IMMEDIATE 'alter system kill session ''' || r.sid
|| ',' || r.serial# || '''';
END LOOP;
END;
/

Comments (0)

Please to add comments

No comments yet. Be the first to comment!