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 vote194 views1 answer
Oracle right characters
SQL
1 vote187 views1 answer
Ilike for date postgres
SQL
28 votes292 views6 answers
Foreign key
SQL
1 vote195 views1 answer
Base nosql
SQL
0 vote197 views4 answers
How to connect form to database
SQL
0 vote196 views2 answers
Sql auto update dupdated_at
SQL
23 votes204 views3 answers
Sql where contains part of string
SQL
2 votes194 views1 answer
Mysql virtual column
SQL
0 vote282 views1 answer
ORA-01400
SQL
0 vote202 views1 answer
Postgress append string in select
SQL