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 vote181 views1 answer
Distinct data types in a table sql query
SQL
0 vote168 views1 answer
Drush run sql select
SQL
0 vote161 views1 answer
Mysql update privileges
SQL
0 vote179 views1 answer
.sql File Run in PSQL
SQL
0 vote169 views1 answer
Mysql wsrep ls
SQL
1 vote167 views2 answers
Sql left characters
SQL
2 votes163 views1 answer
Mysql auto increment jumping
SQL
0 vote214 views1 answer
Stop and start mysql
SQL
2 votes183 views1 answer
Postgresql create table as select
SQL
1 vote210 views2 answers
How to install mysql workbench in ubuntu 20.04
SQL