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 vote173 views2 answers
Postgresql gset
SQL
1 vote193 views1 answer
Convert to hexadecimal sql
SQL
0 vote211 views1 answer
Copy row from db to db mysql
SQL
1 vote190 views1 answer
Oracle activate job
SQL
16 votes173 views6 answers
This is incompatible with sql_mode=only_full_group_by
SQL
0 vote177 views1 answer
Drop all procedures sql server
SQL
0 vote159 views1 answer
Sql server manager close connection
SQL
2 votes154 views1 answer
Oracle create directory
SQL
0 vote171 views1 answer
TSQL Code Snippet For Optimized Sales Query
SQL
0 vote169 views1 answer
Sql contains vs like
SQL