Correct me if I'm wrong, you might be referring to a session from the application server to the database server that was caught trap when let's say application server error occured and not really the instance referred usually here as the database instance.

If my guess is right, you wanted to clear those session that could still be in the database server, and from the application server you have a facility to undo this incomplete transaction.


Well, the database itself has a facility to clean those session that are considered dead connection. But if you really need something from the oracle database to detect and disconnect those dead connection as soon as possible, As far as I can remember there is a way to do that, and it is configured in sqlnet.ora. Please research on Dead Connection Detection.