3 Replies Latest reply: Jan 15, 2013 12:53 AM by Osama_Mustafa RSS

    Regarding kill session

    984741
      Hello Everybody,

      I am new to Oracle. I have few questions regarding session kill.

      1)Does “killed” session consume any system resources like RAM, CPU?

      2)Whether one should kill the process rather than the session?

      3) Does ALTER SYSTEM KILL SESSION command kill both user session and server process?

      With Regards.
        • 1. Re: Regarding kill session
          Sunny kichloo
          For process and sessions refer this.Its quite old post but will help

          http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:5671284058977


          Also for killing a session refer this
          http://www.oracle-base.com/articles/misc/killing-oracle-sessions.php
          • 2. Re: Regarding kill session
            Mihael
            1)Does “killed” session consume any system resources like RAM, CPU?
            yes, till system rolled back session's active transaction
            2)Whether one should kill the process rather than the session?
            only when process remains in system and there is no record for session in v$session
            3) Does ALTER SYSTEM KILL SESSION command kill both user session and server process?
            not "kills", but correctly finishes session and process
            • 3. Re: Regarding kill session
              Osama_Mustafa
              1)Does “killed” session consume any system resources like RAM, CPU?
              Killed Status In v$Session Indicates PMON is too busy to clean up.

              You could refer to
              http://www.oracle-base.com/articles/misc/KillingOracleSessions.php
              2)Whether one should kill the process rather than the session?
              Refer to
              http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:4974573906087
              3) Does ALTER SYSTEM KILL SESSION command kill both user session and server process?
              session is not a process, a process is not a session.

              please refer to Tom Link.