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 vote249 views1 answer
Uncheck constraints and delete from table
SQL
0 vote246 views1 answer
How to read the potentail error messages in ssis package
SQL
0 vote229 views1 answer
Order by ip address sql
SQL
1 vote226 views1 answer
Import in mysql without a software
SQL
1 vote239 views1 answer
Oracle avg
SQL
3 votes241 views3 answers
C# sql select
SQL
0 vote220 views4 answers
Sql limit 1 offset 1
SQL
3 votes232 views4 answers
Order by desc postgres
SQL
3 votes234 views2 answers
Create schema postgres
SQL
8 votes284 views3 answers
Find table for column name in sql
SQL