Killing oracle session in RAC does not work correctly

[Puxmep]

Hello!

PL/SQL Developer v11.0.0 + RAC Oracle 11g

In "Tools -> Sessions" window "Kill" command does not work correctly if "inst_id" "my current inst_id" (we select gv$session instead of default v$session)

You do the command:
ALTER SYSTEM KILL SESSION 'sid,serial#';

It is better to run the command:

ALTER SYSTEM KILL SESSION 'sid,serial#,@inst_id';

Can we expect such a correction in the next releases?

 

[IvanZ]

This could be enhanced to be an enhancement request: Please make command for Kill session user-customizable.

Specifically, I would like to call my pl/sql function, that will do the right stuff.

 

[Puxmep]

I agree with you and support you:

Please make command for Kill session user-customizable!

 

[dda]

+1