Kill session in RAC

Hi,

I have 10 node rac  and  all tables are parallel. If suppose when I run  a query It will create 40 to 60 parallel process. If suppose I want to kill this session  using normal kill session command I could not kill all the parallel process with session.  If any have any idea how to clean up entire session ?
paddy1973Asked:
Who is Participating?
 
jocaveConnect With a Mentor Commented:
What is the "normal kill session command"?  ALTER SYSTEM KILL SESSION 'sid,serial#,instance'?  
What is the error you receive?  
What version of Oracle are you using?
0
 
paddy1973Author Commented:
please  let me know if any procedure help for this?
0
 
paddy1973Author Commented:
yes.  Oracle version is 11g /ASM/10 node RAC.

problem is Session is showing as killed but actually if you see all parallel process related to that session not killed completely.
0
 
MrNedConnect With a Mentor Commented:
If you kill the primary session for the process (make sure you are connected to the correct instance to kill it), the parallel slave processes should stop working. I dont think they will die off though, just go idle waiting for some other session to make use of them.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.