ALTER SYSTEM DISCONNECT SESSION Clause

Use the DISCONNECT SESSION clause to disconnect the current session by destroying
the dedicated server process (or virtual circuit if the connection was made by way of a
Shared Sever). To use this clause, your instance must have the database open. You
must identify the session with both of the following values from the V$SESSION view:
■ For integer1, specify the value of the SID column.
■ For integer2, specify the value of the SERIAL# column.

If system parameters are appropriately configured, then application failover will take
effect.
■ 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 as KILL SESSION.
■ The IMMEDIATE setting disconnects the session and recovers the entire session
state immediately, without waiting for ongoing transactions to complete.
– If you also specify POST_TRANSACTION and the session has ongoing
transactions, then the IMMEDIATE keyword is ignored.
– If you do not specify POST_TRANSACTION, or you specify POST_
TRANSACTION but the session has no ongoing transactions, then this clause
has the same effect as described for KILL SESSION IMMEDIATE.

[@more@]