Categories
dba sql

commit suicide;

Tanel Poder directed me to Miladin Modrakovic blog, I will definitely add this to my prefered feed.

You have to try this :

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

A very decent method for killing yourself 😈

By Laurent Schneider

Oracle Certified Master

8 replies on “commit suicide;”

That is nice!

You can use also event 10237.

Session 1
– – – – – – –
SQL> begin
2 while 2>1 loop
3 null;
4 end loop;
5 end;
6 /

Session 2 (as user SYS or as user who has privilege to execute the package DBMS_SYSTEM.SET_EV)
———-
SQL> exec dbms_system.set_ev(sid,serial#,10237,4,”);
PL/SQL procedure successfully completed.

Session 1
————-

ERROR at line 1:
ORA-01013: user requested cancel of current operation

The session is not killed, user is still connected –
SQL> select * from v$version;

BANNER
——————————————————————————–
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 – 64bit

Leave a Reply

Your email address will not be published.