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

1 vote176 views1 answer
How not to sort by average rating
SQL
0 vote197 views2 answers
Search stored procedures by name
SQL
0 vote169 views1 answer
TSQL convert csv to table
SQL
0 vote194 views1 answer
A network or instance-specific error sql server
SQL
0 vote151 views1 answer
Oracle call a function in a insert statement
SQL
0 vote143 views1 answer
Mysql case when null
SQL
1 vote155 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception table not found
SQL
0 vote167 views1 answer
Time mysql w3
SQL
0 vote150 views1 answer
Postgres populate table from another table
SQL
1 vote146 views1 answer
Join first name and last name sql
SQL