Thursday, June 13, 2013

Kill Session vs Disconnect Session

Today my friend asked me what is the different between kill session and disconnect session. After researching I found useful information and here I`m going to share briefly.

  • Using Disconnect Session clause to disconnect the current session by destroying the dedicated server process.
  • Using Kill Session clause let you mark a session as terminated, release locks.

Example:
SQL>ALTER SYSTEM DISCONNECT SESSION 'sid,serial#';
SQL>ALTER SYSTEM KILL SESSION 'sid,serial#';

For more details please refer to : http://oracletempspace.wordpress.com/2011/04/20/example-alter-sytem-disconnect-vs-alter-system-kill-for-currently-connected-sessions/


5 comments:

  1. Hello, I read your blog occasionally, and I own a similar one, and I was just wondering if you get a lot of spam remarks? If so how do you stop it, any plugin or anything you can advise? I get so much lately it’s driving me insane, so any assistance is very much appreciated.

    Selenium Course Training in Chennai |Best Selenium Training Institute in Chennai
    Java Course Training in Chennai | Best Java Training Institute in Chennai

    ReplyDelete
  2. I went through your blog its really interesting and holds an informative content. oracle training in chennai

    ReplyDelete
  3. It’s great to come across a blog every once in a while that isn’t the same out of date rehashed material. Fantastic read.Java Training in Chennai

    Java Training in Velachery

    Java Training inTambaram

    Java Training in Porur

    Java Training in Omr

    Java Training in Annanagar

    ReplyDelete

Cannot access dba_directories inside procedure

 Recently I faced one of familiar Oracle error ORA -00942 : table or view does not exist   I got it in while compiling procedure, becaus...