Kill session in RAC

Posted on 2009-12-19
Medium Priority
1 Endorsement
Last Modified: 2012-05-08

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 ?
Question by:paddy1973
  • 2

Author Comment

ID: 26088690
please  let me know if any procedure help for this?

Accepted Solution

jocave earned 1000 total points
ID: 26089175
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?

Author Comment

ID: 26092254
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.

Assisted Solution

MrNed earned 1000 total points
ID: 26100899
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.

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
Suggested Courses
Course of the Month16 days, 17 hours left to enroll

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question