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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s