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

6 votes426 views4 answers
Mysql get random row
SQL
0 vote349 views5 answers
Linq cheat sheet
SQL
1 vote311 views2 answers
Delete auto increment mysql
SQL
0 vote335 views1 answer
Install ms sql server management studio
SQL
0 vote363 views1 answer
Mysql page segment
SQL
2 votes388 views1 answer
Q operator in oracle
SQL
0 vote490 views1 answer
Php insert null mysql
SQL
0 vote405 views1 answer
Sql statement show all emails with dome
SQL
0 vote336 views1 answer
Postgres select except
SQL
8 votes378 views1 answer
My sql version
SQL