Script to Kill My Own SQLPLUS Session

advertisements

_____________________________________________________________________________________________________________________

Here I am giving you tip to kill your own sqlplus session connected to the oracle database. 

Syntax

alter session set events 'immediate crash';

Example

SQL> alter session set events 'immediate crash';
alter session set events 'immediate crash'
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 12917
Session ID: 413 Serial number: 11536


SQL> select name from v$database;; 
ERROR:
ORA-03114: not connected to ORACLE

_____________________________________________________________________________________________________________________

Website Stats