OrackeSession.BreakExecution

[cptngrb]

This method doesn't always work. What would you recommend?

 

[Marco Kalter]

It may not work during specific operations that the Oracle Server is performing for the session, such as performing an internal sort or waiting for a lock. After such an operation it should still break though.

I'm not aware of any other option to break execution, except for killing the session from within another session.

 

[cptngrb]

alter system kill session x,y immediate