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 vote134 views1 answer
Postgres read table structure
SQL
1 vote135 views1 answer
Mysql query where in select
SQL
0 vote132 views1 answer
Insert or update cassandra
SQL
0 vote130 views1 answer
Sql get month from date
SQL
0 vote132 views1 answer
Count columns psql(PostreSQL)
SQL
0 vote147 views1 answer
Mysql grouping functions
SQL
0 vote140 views1 answer
Generate sequence number in sql server
SQL
3 votes140 views1 answer
Null sql
SQL
0 vote157 views1 answer
Sql select first and last record of each group
SQL
0 vote128 views1 answer
Check mysql password with docker container magento 2
SQL