Search notes:

Oracle: DBA_JOBS_RUNNING

All (scheduler) jobs in the database which are currently running, join v$lock and job$.
select
  jru.sid,
  jru.last_date,
  jru.this_date,
  jbb.log_User,
  jbb.priv_user,
  jbb.schema_user
from
  dba_jobs_running  jru  join
  dba_jobs          jbb  on jru.job = jbb.job;
Github repository Oracle-Patterns, path: /Installed/data-dictionary/jobs/running/show.sql

See also

dba_jobs

Index