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

0 vote181 views1 answer
Sql check if field is not null
SQL
1 vote136 views3 answers
Get all tables postgres
SQL
8 votes132 views1 answer
Today minus 15 days postgresql
SQL
4 votes137 views1 answer
Mysql timestamp in laravel migration
SQL
0 vote160 views1 answer
Carbon mysql d m y to y-m-d
SQL
-1 vote149 views1 answer
Mysql change database charset and collation
SQL
0 vote153 views2 answers
Starts and end with vowel sql
SQL
0 vote133 views1 answer
Max length found in mysql
SQL
14 votes137 views4 answers
Remove record from table sql
SQL
0 vote148 views1 answer
Distance calculator from lat long sql query
SQL