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
Post a Comment