How to see the jobs currently being executed?

Using dba_jobs_running it will show the all jobs executing.

SQL> select djr.sid, djr.job, djr.failures, djr.this_date, djr.this_sec, dj.what from dba_jobs_running djr, dba_jobs dj where djr.job = dj.job;

SID JOB FAILURES THIS_DATE THIS_SEC
———- ———- ———- ——————– ——–
WHAT
—————————————————————————————————-

68 21 0 19-feb-2012 21:09:34 21:09:34
dbms_lock.sleep(100);

Leave a Reply