Thread: Oracle wait events

Hi,

A job is running long. When checking session browser for waits it showing current wait as latch free also in columns of total_wait,avg wait some values are there. How to find whether the job is progressing or not also any ration to calculate wait events. eg: if wait value higer than 44535(eg value) do a process. Any anwer will be help full.

Check from dba_jobs_running.

Originally Posted by thilamzn

Hi,

A job is running long. When checking session browser for waits it showing current wait as latch free also in columns of total_wait,avg wait some values are there. How to find whether the job is progressing or not also any ration to calculate wait events. eg: if wait value higer than 44535(eg value) do a process. Any anwer will be help full.

To find the job is running use
SELECT r.sid, r.job, r.this_date, r.this_sec, SUBSTR(what,1,40) what
FROM dba_jobs_running r,dba_jobs j
WHERE r.job = j.job;
use below query to find the status of the job
SELECT job, next_date, next_sec, failures, broken, SUBSTR(what,1,40) DESCRIPTION
FROM user_jobs;