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

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.