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
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
Comment