How to Kill My Own SQLPLUS Session

_____________________________________________________________________________________________________________________


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

_____________________________________________________________________________________________________________________

0 comments:

Post a Comment

 

acehints.com Copyright 2011-19 All Rights Reserved | Site Map | Contact | Disclaimer | Google