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 vote298 views1 answer
Compression of dabatase mysqldumo
SQL
0 vote352 views1 answer
Sql show founctions
SQL
0 vote318 views2 answers
Homebrew nysql launch
SQL
0 vote343 views1 answer
Postgres list tables and row counts
SQL
0 vote327 views1 answer
Oracle session statistics
SQL
0 vote312 views1 answer
Regex any word except sql
SQL
1 vote343 views1 answer
Mysql workbench requires visual c++ 2019 redistributable package
SQL
6 votes320 views3 answers
Oracle all dates between two dates
SQL
1 vote310 views3 answers
Mysql connection string
SQL
0 vote298 views1 answer
Login failed for login due to trigger execution
SQL