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

59 votes546 views6 answers
Alter table sql
SQL
3 votes333 views2 answers
Find the median in sql
SQL
8 votes314 views1 answer
Mysql restore database
SQL
7 votes349 views2 answers
Phpmyadmin change password
SQL
2 votes314 views2 answers
Checking data type in sql server
SQL
0 vote303 views1 answer
Access refused mysql xampp server
SQL
1 vote335 views1 answer
Mysql not supported auth mode
SQL
3 votes308 views2 answers
Having in mysql
SQL
0 vote354 views1 answer
Mysql last friday of current month
SQL
16 votes339 views6 answers
This is incompatible with sql_mode=only_full_group_by
SQL