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

-2 votes188 views1 answer
Modify column name in tsql
SQL
0 vote202 views1 answer
"SET SQL_AUTO_IS_NULL = 0" query problem
SQL
0 vote206 views1 answer
How we can perform acid Operations in sql with examples
SQL
1 vote198 views1 answer
Oracle compile schema
SQL
3 votes207 views3 answers
Mysql declare variable
SQL
0 vote216 views1 answer
Mysql url
SQL
0 vote214 views1 answer
Sql gather statistics to increase performance
SQL
0 vote189 views1 answer
Psql use query result convert Decimal python numpy psycopg2
SQL
31 votes189 views3 answers
Sql count
SQL
-1 vote205 views1 answer
Ssql to lowercqse
SQL