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

17 votes143 views4 answers
Sort by mysql
SQL
2 votes155 views1 answer
How to make multiple keys as primary in bdms
SQL
0 vote140 views1 answer
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'edxapp.app_feedback feedback category' doesn't exist")
SQL
0 vote149 views1 answer
Get server date mysql
SQL
35 votes172 views5 answers
Sql alter column
SQL
10 votes143 views1 answer
Oracle view dependencies
SQL
0 vote144 views1 answer
Mysqldump ignore table
SQL
3 votes138 views1 answer
Search for column name in psql
SQL
0 vote140 views1 answer
Select from another database
SQL
0 vote193 views1 answer
Php insert null mysql
SQL