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 vote186 views1 answer
List column names of multiple tables psql
SQL
0 vote204 views1 answer
Mysql custom sort order
SQL
0 vote276 views1 answer
Sql select max value for each group
SQL
0 vote259 views1 answer
Php insert null mysql
SQL
0 vote188 views3 answers
Select random sql
SQL
0 vote243 views1 answer
Delete from table where length sql
SQL
0 vote215 views1 answer
Second Step in installing SQL workbench
SQL
1 vote195 views1 answer
How to drop function in sql
SQL
2 votes201 views1 answer
Oracle convert run_duration to number
SQL
2 votes186 views1 answer
Oracle number to percentage
SQL