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

1 vote130 views1 answer
Update substring in mysql
SQL
4 votes118 views2 answers
SELECT table_name FROM user_tables;
SQL
11 votes138 views1 answer
Ddl view
SQL
0 vote113 views1 answer
Group by two columns postgres
SQL
0 vote132 views2 answers
Pl sql auto increment
SQL
0 vote119 views1 answer
Group by join columns per table
SQL
1 vote111 views1 answer
Sql try catch
SQL
49 votes121 views6 answers
Get duplicate records in sql
SQL
0 vote67 views1 answer
Como leer datos de mysql esp32
SQL
1 vote115 views1 answer
Mysql select if empty result
SQL