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 vote147 views2 answers
Find Overlapping sql
SQL
1 vote154 views1 answer
How to remove identity from a column in sql server
SQL
0 vote149 views1 answer
Like sql for second letter of the family name
SQL
0 vote171 views1 answer
Mysql add text to existing field
SQL
0 vote189 views2 answers
Mysql show foreign keys
SQL
0 vote166 views1 answer
How to locate pg_hba.conf file
SQL
4 votes146 views3 answers
Order by value mysql
SQL
18 votes179 views3 answers
Mysql add column default value
SQL
1 vote155 views1 answer
Generate random data postgresql
SQL
38 votes226 views4 answers
Count sql
SQL