Script to Kill My Own SQLPLUS Session

_____________________________________________________________________________________________________________________

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 (578) General (60) Unix (47) Script (41) Blog (23) OCI (3) SQL* Loader (3) Datapump (2) Software (1)
DBA Tips
 

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