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
Tag: dba_scheduler_running_jobs
How to find jobs currently running or history about the jobs?
In 10g one can find the jobs that are currently running by querying the following view SELECT job_name, session_id, running_instance, elapsed_time, cpu_used FROM dba_scheduler_running_jobs; Also one can use the following view to find the history details of job that has run. SELECT job_name, log_date, status, actual_start_date, run_duration, cpu_used FROM dba_scheduler_job_run_details; To find the jobs that … Continue reading How to find jobs currently running or history about the jobs?
alexlima.com 