What is the difference between disconnect session and kill session in the Session Browser of Toad for Oracle?
The difference between disconnect session and kill session in the Session Browser of Toad for Oracle:
The DISCONNECT SESSION is to disconnect the current session by ending the dedicated server process. If you check the IMMEDIATE bullet (if you do not specify POST TRANSACTION, or if you specify POST TRANSACTION but the session has no ongoing transactions) then this clause has the same effect as KILL SESSION IMMEDIATE. Disconnect session kills the circuit, but not the shared server or dispatcher server process; disconnect immediate (without post transaction) is the same as kill session. Disconnect session will allow any transaction to finish before the user is disconnected, then will be marked as kill.
The KILL SESSION has the server mark the session and its resources as killed; however, before the session is released, the client must initiate the disconnect. The session will not be killed until the client issues a sql statement or disconnects.
For more information: go to Toad | Help | Contents | Index Tab | Type in "Session Browser" | Double click "Kill/Trace" | Double click "Kill Sessions"
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center