Killing a process and a session

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • eeriehunk
    New Member
    • Sep 2007
    • 55

    Killing a process and a session

    Hi All,
    I am a little confused between a session and a process. I learnt that an Oracle Session is created for every login. And we can run many processes in one session. I have also learnt how to identify a session using V$SESSION and kill it (using ALTER SYSTEM KILL SESSION ‘SID’). By killing a session, kills all the processes ? Or am I getting this all wrong. Kindly explain of forward me to a good link. I tried to Google, but it tells only about sessions and not processes.
    Regards,
    Aj
  • debasisdas
    Recognized Expert Expert
    • Dec 2006
    • 8119

    #2
    To kill a process you need to kill the session through which you are excuting the process.

    Comment

    • eeriehunk
      New Member
      • Sep 2007
      • 55

      #3
      Originally posted by debasisdas
      To kill a process you need to kill the session through which you are excuting the process.
      Hi, Thanks for your reply. So does that mean, every process has a session and one session can't hold more then one process.
      Regards,
      Aj

      Comment

      • debasisdas
        Recognized Expert Expert
        • Dec 2006
        • 8119

        #4
        Originally posted by eeriehunk
        Hi, Thanks for your reply. So does that mean, every process has a session and one session can't hold more then one process.
        Regards,
        Aj
        Question #1. Yes
        Question #2. No

        Comment

        Working...