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

8 votes141 views3 answers
Alter user root mysql
SQL
11 votes145 views1 answer
Ddl materialized view
SQL
6 votes159 views3 answers
Mysql remove user privileges
SQL
3 votes141 views1 answer
Oracle list privileges
SQL
-1 vote140 views3 answers
Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
0 vote94 views3 answers
Django.core.exceptions.improperlyconfigured: error loading mysqldb module. mac
SQL
0 vote154 views1 answer
Duplix print in Smartforms
SQL
12 votes146 views4 answers
Mysql version query
SQL
5 votes174 views1 answer
Oracle sysdate - 1 month
SQL
8 votes101 views2 answers
Alter column name in mssql
SQL