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

3 votes284 views2 answers
Funktion LOWER/UPPER sql
SQL
4 votes304 views4 answers
Pl sql output
SQL
4 votes290 views1 answer
Sql group by year
SQL
0 vote287 views1 answer
Sql insert tuple
SQL
0 vote282 views1 answer
Mysql create table like
SQL
5 votes299 views1 answer
Mysql created at yesterdau
SQL
-1 vote296 views2 answers
Mysql error 1064 you have an error in your sql syntax
SQL
0 vote306 views1 answer
Sql developer search all packages for text
SQL
16 votes325 views6 answers
Mysql find duplicates in same table
SQL
-1 vote290 views2 answers
Get day in sql
SQL