how can i avoid logging directly to the node that is running the session to kill it

I can find what I want to kill with gv$session, but I have to log directly into that node to kill it.

تم تعديل 12 مارس 200520 سنة بواسطة reem_77

you cannot kill other instance's session, but you can get the SID and SERAL# of the sessions from other instances by querying gv$instance view (from any sessions in RAC). In order to issue the ALTER SYSTEM KILL SESSION, you have to be also connected to the same instance

بوركت يا عبد الله

The ALTER SYSTEM would have to be issued on the instance that has the session you want to kill. You could try a DBMS_JOB to submit the command to run on that particular instance. It would have to EXECUTE IMMEDIATE the ALTER command. If you want it more seamless, you'd want an autonomous transaction to submit the job to avoid committing in your own session.

Good Example

Example.txt

مثال رائع اخى فى الله المهندس خالد
جزاك الله كل خير و دائما اخوانى نستخدم نظرية التجربة لانها تمكنك من توفيذ جميع الا حتمالات و ايضاً تتيح لك انت استنتاج النتائج

Hi

if you plz try to specified the method in more detail I don't know how i dealing with DBMS_JOB to submit the command to run on that particular instance