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 vote220 views1 answer
Tsql table column constraint must be uppercase
SQL
0 vote147 views1 answer
Insert and initialize a SQL column with value dependent on another column data
SQL
4 votes202 views2 answers
Show all database inside postgresql
SQL
16 votes253 views6 answers
Python sqlite
SQL
1 vote209 views1 answer
Best sql course
SQL
1 vote221 views1 answer
Convert to hexadecimal sql
SQL
1 vote396 views2 answers
Coderbyte sql solutions
SQL
11 votes205 views3 answers
How to get last row of table in sql
SQL
0 vote284 views1 answer
Do you know sql
SQL
0 vote270 views1 answer
Consulta alias con inner join
SQL