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.

Comments

Popular posts from this blog

Find and replace with sed command in Linux

Find and replace feature is always handy. It can turn into a torture when it comes to change or delete a simple constant string in a text file. There is a handy tool in linux for doing these kind of tihngs. Actually sed is not a text editor but it is used outside of the text file to make changes.