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 vote108 views1 answer
Mysql query with sql to get the next row
SQL
0 vote109 views2 answers
Py sqlite if entry exists
SQL
4 votes145 views1 answer
Fatal error: libpq-fe.h: No such file or directory
SQL
0 vote100 views1 answer
Mysql remove tabs from string
SQL
0 vote117 views1 answer
Replace divide by zero error with 0 in sql
SQL
5 votes97 views1 answer
Update sql user password
SQL
0 vote98 views1 answer
Mysql workbench indent formatting
SQL
6 votes141 views2 answers
Subtr Oracle ?
SQL
1 vote106 views1 answer
Mysql get latest duplicate rows
SQL
4 votes118 views2 answers
Bulk kill mysql processlist
SQL