oracle show running job

1SELECT * FROM USER_SCHEDULER_RUNNING_JOBS;		-- connected scheme
2SELECT * FROM ALL_SCHEDULER_RUNNING_JOBS;		-- granted to connected scheme
3SELECT * FROM DBA_SCHEDULER_RUNNING_JOBS;		-- all jobs (DBA)
4
5-- More details (DBA)
6SELECT DISTINCT r.OWNER, r.JOB_NAME, r.JOB_SUBNAME, r.ELAPSED_TIME, r.CPU_USED,
7                d.ACTUAL_START_DATE
8FROM DBA_SCHEDULER_RUNNING_JOBS r
9         LEFT JOIN DBA_SCHEDULER_JOB_RUN_DETAILS d
10                   ON d.SLAVE_PID = r.SLAVE_PROCESS_ID
11ORDER BY r.OWNER, r.JOB_NAME, r.JOB_SUBNAME;