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 vote350 views4 answers
Restart MySQL
SQL
8 votes355 views2 answers
Mysql get first x characters
SQL
10 votes301 views2 answers
Django mysql
SQL
1 vote348 views3 answers
Nth highest salary
SQL
4 votes334 views2 answers
Select first and last row mysql
SQL
1 vote343 views1 answer
Mysql check if string contains comma separated
SQL
0 vote366 views1 answer
Datatables server side filter where clause
SQL
3 votes321 views2 answers
Oracle synonym
SQL
0 vote338 views1 answer
Get db connection detail from sql developer profile
SQL
4 votes320 views1 answer
Mysql ip address
SQL