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 vote148 views1 answer
ERROR: column "hourly_visitors.hour" must appear in the GROUP BY clause or be used in an aggregate function
SQL
7 votes152 views3 answers
Can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
SQL
3 votes117 views1 answer
Difference sql vs mysql
SQL
1 vote165 views1 answer
Sql oracle update multiple rows
SQL
0 vote145 views1 answer
Codigo crear tablas sql server
SQL
1 vote85 views1 answer
Python escape string for sql
SQL
0 vote95 views1 answer
Requete sql mise a jour content dans un colone mysql
SQL
5 votes132 views1 answer
Oracle sysdate
SQL
1 vote133 views1 answer
Show all event schedular on mysql
SQL
1 vote134 views1 answer
Mysql text to decimal
SQL