Ending a session

[andyp05]

Is there anyway to end a session and free the datamodule if a user attempts an update with a blocking lock. Right now, they are 'Ending Task'. Is there a way we can more gracefully end the session and free the datmodule? BreakExecution does not work in this case.

Thanks in advance.

 

[Marco Kalter]

The most graceful method is to kill the session (alter system kill session ...) from within another session. This requires a connection that has the "alter system" privilege. You also need to know the sid and serial of the locked session.