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 vote286 views1 answer
How to pass list as parameter in SQL query
SQL
2 votes309 views1 answer
Sql compare strings
SQL
1 vote238 views1 answer
Sql update table remove spaces
SQL
0 vote272 views1 answer
Get current date data in mysql
SQL
0 vote240 views1 answer
How to Group by and concatenate arrays with all columns in PostgreSQL
SQL
0 vote256 views2 answers
Demmarrer un service mysql teminal cmd
SQL
-1 vote264 views1 answer
Concat two columns in sql server
SQL
0 vote272 views1 answer
How to find table lock and row lock in mysql
SQL
0 vote290 views1 answer
Joomla execute raw sql
SQL
0 vote233 views1 answer
Hallo
SQL