Script to Kill My Own SQLPLUS Session

advertisements

_____________________________________________________________________________________________________________________

The Eucharistic Miracles of the World
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

0 comments:

Post a Comment

Labels

Oracle (629) Script (86) General (77) Unix (47) Blog (23) Technology (19) gadget (6) games (6) Business (3) OCI (3) SQL* Loader (3) Datapump (2)
 

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