8 thoughts on “commit suicide;”

  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;

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

Leave a Reply

Your email address will not be published.


*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>