Home Oracle Commands Oracle Data Dictionary
v$ Performance views

DBA_JOBS_RUNNING

All jobs in the database which are currently running, join v$lock and job$

Columns
   ___________________________
 
   THIS_DATE
      Date that this job started executing (usually null if not executing)
   SID
      Identifier of process which is executing the job.  See v$lock.
   JOB
      Identifier of job.  This job is currently executing.
   FAILURES
      How many times has this job started and failed since its last success?
   LAST_DATE
      Date that this job last successfully executed
   THIS_SEC
      Same as THIS_DATE.  This is when the last successful execution started.
   LAST_SEC
      Same as LAST_DATE.  This is when the last successful execution started.
   INSTANCE
      The instance number restricted to run the job

Related Commands:




Back to the Top

Simon Sheppard
SS64.com