Oracle show running job

SELECT * FROM USER_SCHEDULER_RUNNING_JOBS;		-- connected scheme
SELECT * FROM ALL_SCHEDULER_RUNNING_JOBS;		-- granted to connected scheme
SELECT * FROM DBA_SCHEDULER_RUNNING_JOBS;		-- all jobs (DBA)

-- More details (DBA)
SELECT DISTINCT r.OWNER, r.JOB_NAME, r.JOB_SUBNAME, r.ELAPSED_TIME, r.CPU_USED,
                d.ACTUAL_START_DATE
FROM DBA_SCHEDULER_RUNNING_JOBS r
         LEFT JOIN DBA_SCHEDULER_JOB_RUN_DETAILS d
                   ON d.SLAVE_PID = r.SLAVE_PROCESS_ID
ORDER BY r.OWNER, r.JOB_NAME, r.JOB_SUBNAME;

Similar codes

9 votes250 views4 answers
Oracle get table column names
SQL
0 vote247 views1 answer
Postgresql find biggest table
SQL
0 vote228 views1 answer
Get created time of database psql 8
SQL
1 vote206 views1 answer
Type int in mysql maxlenght
SQL
10 votes217 views6 answers
Between sql
SQL
1 vote209 views2 answers
Regex starts with
SQL
0 vote211 views1 answer
Oracle change password expiration policy
SQL
29 votes200 views5 answers
Mysql show table structure
SQL
5 votes192 views1 answer
Mysql get last day of month
SQL
0 vote198 views1 answer
Mysql count by month
SQL