If you ask for the session to be killed POST TRANSACTION, you have to
wait for the transaction to complete before you see the session
removed. It is likely that the session is still in the midst of a
transaction. As soon as there is a COMMIT or ROLLBACK, the session will
be killed. If you wanted it to occur immediately, you should have used
the IMMEDIATE option, though that would mean that the current
transaction is rolledback. This rollback could take a few seconds to a
few hours, depending upon how large the transaction was, so even then
you won't see the session be removed immediately.
You can't kill a session and expect the changes so far to be saved.
That would violate the integrity of a transaction.
Received on Thu Sep 01 2005 - 08:45:38 CDT
