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 vote136 views1 answer
Default username and password for oracle 11g
SQL
0 vote137 views2 answers
How to get max from each department in sql
SQL
13 votes117 views6 answers
Current date sql
SQL
0 vote141 views1 answer
Permission denied postgres \copy csv command line
SQL
1 vote140 views3 answers
Mysql on delete set null
SQL
1 vote154 views1 answer
Sql select sum group by id laravel
SQL
0 vote131 views1 answer
MySQL - Enabling the Event Scheduler
SQL
11 votes154 views6 answers
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
SQL
3 votes142 views1 answer
Oracle apex message quit website
SQL
0 vote129 views1 answer
Create table in mysql mariadb primary key foreign key
SQL