<div>
please &nbsp;let me know if any procedure help for this?
</div>


please  let me know if any procedure help for this?

<div>
yes. &nbsp;Oracle version is 11g /ASM/10 node RAC.<br />
<br />
problem is Session is showing as killed but actually if you see all parallel process related to that session not killed completely.
</div>


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.

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have 10 node rac &nbsp;and &nbsp;all tables are parallel. If suppose when I run &nbsp;a query It will create 40 to 60 parallel process. If suppose I want to kill this session &nbsp;using normal kill session command I could not kill all the parallel process with session. &nbsp;If any have any idea how to clean up entire session ?
</div>
</div>


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 ?

Kill session in RAC

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.