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

4 votes233 views2 answers
Show all database inside postgresql
SQL
4 votes241 views1 answer
Group by mysql and concatenate string
SQL
1 vote237 views3 answers
Drop unique key constraint in sql server
SQL
7 votes222 views2 answers
Sql server drop temp table if exists
SQL
0 vote217 views1 answer
What is between operator
SQL
1 vote224 views1 answer
Sql server select rows by distinct column
SQL
0 vote252 views1 answer
Check if a column is a primary key in sql server
SQL
0 vote215 views1 answer
Remove from table where
SQL
2 votes233 views1 answer
Mysql trigger after update
SQL
0 vote224 views1 answer
Do postgresql
SQL