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 vote363 views1 answer
Sqlite woth cmake
SQL
0 vote346 views1 answer
Table or view does not exist
SQL
14 votes319 views2 answers
Sql cast
SQL
0 vote439 views2 answers
Sqlalchemy default value for column
SQL
2 votes357 views1 answer
Sql string_agg
SQL
0 vote336 views1 answer
Mssql check if date is greater than today
SQL
0 vote312 views1 answer
Grant owner postgresql
SQL
0 vote340 views1 answer
Install sql server in ubuntu 20.04
SQL
0 vote361 views1 answer
Query to remove duplicate rows from a table
SQL
0 vote367 views1 answer
Get only one row in mysql
SQL