Using DBA_SCHEDULER_RUNNING_JOBS one can see jobs currently running. In the example below it shows the oracle session id and corresponding OS process id. 22:20:51 sys@TESTDB> select job_name, session_id from dba_scheduler_running_jobs; JOB_NAME SESSION_ID ------------------------------ ---------- GATHER_STATS_JOB 364 1 row selected. sys@TESTDB> select program from v$session where sid = 364; PROGRAM ------------------------------------------------ oracle@hostname (J002) 1 row selected. … Continue reading dba_scheduler_running_jobs →