Thursday, February 6, 2014
How to find and kill the DBMS jobs running
select job_name, session_id, running_instance, elapsed_time, cpu_used
from dba_scheduler_running_jobs;
JOB_NAME SESSION_ID RUNNING_INSTANCE
------------------- ---------- ----------------
JOB_DEL_PROJECTS 67 4
Now you can stop the job using
exec DBMS_SCHEDULER.stop_JOB (job_name => 'JOB_DEL_PROJECTS');
or you can kill the SID
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment