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 vote117 views1 answer
Update table sql multiple set
SQL
0 vote134 views1 answer
Sql injection payload list github
SQL
2 votes115 views1 answer
Anonymous block plsql
SQL
0 vote127 views1 answer
Custom row number
SQL
1 vote188 views1 answer
Truncate table in postgresql and reset id
SQL
3 votes118 views1 answer
Null sql
SQL
0 vote123 views1 answer
Datagrip execute procedure
SQL
0 vote126 views1 answer
IS THEre any difference between using default and := in plsql
SQL
7 votes123 views3 answers
Python and mysql connectivity
SQL
1 vote123 views1 answer
Error code 1292 mysql workbench
SQL