Today I would like to talk about the option to kill a connection with the post_transaction clause, it looks like the shutdown transactionl that the database has. In this case you wait for the process to finish its work.
- The POST_TRANSACTION setting allows ongoing transactions to complete before the session is disconnected.
- If the session has no ongoing transactions, then this clause has the same effect described for the KILL SESSION.
An example would be the following;
ALTER SYSTEM DISCONNECT SESSION ‘sid, serial #’ POST_TRANSACTION
HTH – Antonio NAVARRO