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

4 votes206 views1 answer
Oracle user tables
SQL
11 votes188 views2 answers
Insert current date sql
SQL
0 vote167 views1 answer
SQL division of an integer by another integer get float CAST
SQL
0 vote222 views1 answer
Virtuoso sql query tutorial
SQL
3 votes173 views1 answer
Start mysql server linux terminal
SQL
0 vote201 views1 answer
Least spark sql
SQL
0 vote212 views1 answer
Local pg_sql to heroku pg_sql
SQL
3 votes192 views2 answers
Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
SQL
4 votes202 views1 answer
Oracle nls_date_format
SQL
0 vote174 views1 answer
How to define a save method in ruby for sql databases
SQL