Skip to main content

Do not kill wrong session

Killing sessions are dangerous. So you have to be careful not to accidentally kill wrong sql session. You may follow the procedure below:

Determine which session to close:
SQL> select sid, serial# from v$session where sid=1040;
SID                         SERIAL#
———-                   ———-
1040                        26444

Kill the session:
SQL> alter system kill session '1040,26444';
System altered.


Popular posts from this blog