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

5 votes294 views2 answers
How to ascending order in sql
SQL
0 vote120 views1 answer
Sql server inner join convert collation
SQL
0 vote199 views1 answer
Site:av.ru "files"
SQL
4 votes130 views1 answer
Find tables with column name in sql
SQL
1 vote124 views1 answer
How to test for sql injection
SQL
0 vote129 views1 answer
Selects all the columns from the sailors table
SQL
0 vote177 views1 answer
Osm2pgsql mac
SQL
0 vote157 views1 answer
Many rows to 1 string mysql
SQL
0 vote125 views1 answer
Equi joins in oracle
SQL
1 vote176 views1 answer
Oracle see column type
SQL