oracle Scripts to check DBMS jobs running

Scripts to check DBMS jobs running
======================================



select job_name, session_id, running_instance, elapsed_time, cpu_used
from dba_scheduler_running_jobs;





if you want to stop job, you can stop by using  below command (or) kill by using SID
===============================================================


exec DBMS_SCHEDULER.stop_JOB (job_name => '<JOB_NAME>');


No comments:

Post a Comment

Common Oracle Clusterware crsctl commands

  Oracle Clusterware crsctl commands: # Check cluster status crsctl check crs crsctl check cluster # Cluster resources crsctl status reso...