![]() Just issue the ALTER SYSTEM KILL SESSION command. * If they are trying to kill a session on this instance First see if the session really exists. L_this_instance_name v$instance.instance_name%TYPE ![]() L_this_instance_number v$instance.instance_number%TYPE L_instance_name gv$instance.instance_name%TYPE P_instance_number IN gv$instance.instance_number%TYPE * - */ĬREATE OR REPLACE PROCEDURE SYS.rac_kill_session GRANT SELECT ON dbms_job_errors TO PUBLIC , CONSTRAINT dbms_job_errors_pk PRIMARY KEY (job_number, failure_date)ĬREATE OR REPLACE PUBLIC SYNONYM dbms_job_errors FOR dbms_job_errors ![]() , failure_date DATE DEFAULT SYSDATE NOT NULL ![]() Please offer your advice on if it is "evil" or not.ĭROP TABLE dbms_job_errors CASCADE CONSTRAINTS ĬREATE TABLE dbms_job_errors (job_number INTEGER NOT NULL Hopefully it will help other RAC users out there. I believe this code will do what you propose. I saw your recommendation for this - and I ran with it.
0 Comments
Leave a Reply. |