By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
449,079 Members | 916 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 449,079 IT Pros & Developers. It's quick & easy.

Killing a process and a session

P: 55
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
Mar 23 '09 #1
Share this Question
Share on Google+
3 Replies


debasisdas
Expert 5K+
P: 8,127
To kill a process you need to kill the session through which you are excuting the process.
Mar 23 '09 #2

P: 55
@debasisdas
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
Mar 23 '09 #3

debasisdas
Expert 5K+
P: 8,127
@eeriehunk
Question #1. Yes
Question #2. No
Mar 23 '09 #4

Post your reply

Sign in to post your reply or Sign up for a free account.