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 vote275 views2 answers
Null value in column violates not-null constraint
SQL
5 votes294 views2 answers
Mysql create database charset utf8mb4
SQL
2 votes263 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly.
SQL
0 vote281 views1 answer
R2dbc-postgresqldriver dependency
SQL
0 vote324 views3 answers
Characters found after end of sql statement
SQL
4 votes265 views1 answer
Mysql insert from local csv
SQL
2 votes271 views2 answers
Mysql date range
SQL
2 votes292 views2 answers
Get all tables using like
SQL
4 votes286 views1 answer
Group by mysql and concatenate string
SQL
3 votes258 views1 answer
Mysql UPDate with enner join
SQL