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

3 votes223 views2 answers
Sql asc
SQL
0 vote224 views1 answer
Linebreak sql
SQL
3 votes250 views1 answer
Laravel paginate raw sql
SQL
0 vote247 views1 answer
Mysql faster delete
SQL
4 votes219 views1 answer
Invalid reference to FROM-clause entry for table "unidades
SQL
0 vote227 views1 answer
How to read the potentail error messages in ssis package
SQL
0 vote268 views1 answer
How to add auto increment primary key
SQL
0 vote244 views1 answer
Python sql passer des parametres dans une requet pymysql
SQL
0 vote235 views1 answer
Mariadb set vertical output format
SQL
1 vote216 views1 answer
How to delete a record from sqlite in android
SQL