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 😈

Published by Laurent Schneider

Oracle Certified Master

Join the Conversation


  1. 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;

    Oracle Database 11g Enterprise Edition Release – 64bit

Leave a comment

Your email address will not be published.