Incorrect active sessions in oracle monitor

[E. van der Poll]

If a (delphi) application using Direct Oracle Access that has made (or tried to make) a connection to Oracle is terminated through the Windows Task Manager or by using Reset in the delphi IDE Run menu, there remains an active session in the Oracle monitor. This session is also visible when the monitor has been started after the applications have been terminated, so it seems there remains some entry in the Oracle client itself.

Is there any way to prevent this, or to detect and remove these sessions either from the monitor or from the application? Removing inactive sessions in the monitor does not help, because these sessions remain "active".

 

[Marco Kalter]

If you terminate an application by killing the process, then it cannot communicate to the Oracle Monitor that it has exited. I don't immediately see a solution for this.