IMMEDIATE clause with KILL SESSION:
instruct Oracle to roll back ongoing transactions, release all session locks, recover the entire session state, and return control to you immediately.
IMMEDIATE clause with DISCONNECT SESSION:
disconnects the session and recovers the entire session state immediately, without waiting for ongoing transactions to complete.




Reply With Quote