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 votes110 views2 answers
Sql add year to date
SQL
1 vote127 views1 answer
Mysql select for update ejemplo
SQL
1 vote102 views1 answer
Mysql server does not start mac
SQL
0 vote111 views1 answer
How to connect sqlalchemy to mysql and deploy it
SQL
0 vote109 views1 answer
Sql server get date of previous sunday
SQL
0 vote113 views2 answers
Temp Space
SQL
0 vote111 views1 answer
How to add session data into mysql database from button
SQL
11 votes118 views2 answers
Turn off safe mode mysql
SQL
0 vote116 views1 answer
Convert polygon to text in mysql
SQL
3 votes124 views1 answer
Oracle cannot access v$session
SQL