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 vote282 views1 answer
Unique index in mysql
SQL
0 vote266 views1 answer
Strat with in sql
SQL
11 votes315 views2 answers
Oracle source code
SQL
19 votes305 views3 answers
How to change column type psql
SQL
0 vote279 views1 answer
PG::ForeignKeyViolation: ERROR: update or delete on table violates foreign key constraint
SQL
0 vote262 views0 answer
SQL
0 vote279 views2 answers
Mysql select date from datetime
SQL
0 vote269 views1 answer
Mssql describe stored procedure sqlcmd
SQL
2 votes310 views5 answers
Install postgresql 10 centos 7
SQL
-1 vote324 views1 answer
Get month and year from date in mysql sequelize
SQL