alter system disconnect session

[toshi]

Hello gurus!

Here's a simple question that I can't seem to find the answer from any oracle documents (or maybe I'm not trying hard enough)...

What is the difference of the following commands:

ALTER SYSTEM DISCONNECT SESSION '9,3' IMMEDIATE
and
ALTER SYSTEM KILL SESSION '9,3' IMMEDIATE

Thanks in advance

Best Regards,
toshi

[stmontgo]

the differences appear to be clearly documented

http://download-west.oracle.com/docs...23.htm#2053604

what are you confused about?

[toshi]

Sorry, my previous post seems not to be so clear.
Here is what I am confused about:

When you issue the command: ALTER SYSTEM KILL SESSION '13, 8';
The statement kills the session with SID 13 and SERIAL# 8

When you issue the command: ALTER SYSTEM DISCONNECT SESSION '13, 8' POST_TRANSACTION;
The statement disconnects the session with SID 13 and SERIAL# 8

Not much of a difference, isn't it?

I know that the later waits for the transaction to finish before disconnecting the user but the document (http://download-west.oracle.com/doc..._23.htm#2053604) didn't tell us that, did it?

Now what I'm confused about is the 'IMMEDIATE' clause when used with 'DISCONNECT SESSION' and 'KILL SESSION'. Or maybe there is no difference but I just want to know.

Thanks for your reply

[julian]

Originally posted by toshi

Now what I'm confused about is the 'IMMEDIATE' clause when used with 'DISCONNECT SESSION' and 'KILL SESSION'. Or maybe there is no difference but I just want to know.

Thanks for your reply

There is difference. With "kill" you mark the session as dead, rollback ongoing transactions, release all session locks, and partially recover session resources. With "disconnect" you only destroy the dedicated process (or the circuit).

[agasimani]

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.

[toshi]

Thanks for your replies!!!