Killing your own session

July 29th, 2009 No Comments   Posted in Oracle Tip

Ever wanted to kill your own session? You know commit suicide; This works nicely:

alter session set events 'immediate crash';

Nothing like a ORA-03113: end-of-file on communication channel to brighten your day.