Connecting Tech Pros Worldwide Forums | Help | Site Map

Killing a process and a session

Member
 
Join Date: Sep 2007
Posts: 55
#1: Mar 23 '09
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's Avatar
Moderator
 
Join Date: Dec 2006
Location: Bangalore ,India
Posts: 7,511
#2: Mar 23 '09

re: Killing a process and a session


To kill a process you need to kill the session through which you are excuting the process.
Member
 
Join Date: Sep 2007
Posts: 55
#3: Mar 23 '09

re: Killing a process and a session


Quote:

Originally Posted by debasisdas View Post

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
debasisdas's Avatar
Moderator
 
Join Date: Dec 2006
Location: Bangalore ,India
Posts: 7,511
#4: Mar 23 '09

re: Killing a process and a session


Quote:

Originally Posted by eeriehunk View Post

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
Reply