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

36 votes275 views6 answers
Rename table sql
SQL
4 votes273 views3 answers
Is not null sql
SQL
9 votes260 views1 answer
Oracle get table schema
SQL
4 votes272 views1 answer
Datepart postgres
SQL
0 vote277 views1 answer
Sql last 3 rows
SQL
2 votes270 views1 answer
Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
SQL
0 vote258 views1 answer
Sql find leading space
SQL
2 votes269 views1 answer
Mariadb JSON_EXTRACT
SQL
0 vote260 views1 answer
Display first three characters sql
SQL
1 vote288 views1 answer
Oracle sql pad left zeros
SQL