-
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.
-
Re: Oracle wait events
Check from [b]dba_jobs_running[/b].
-
Re: Oracle wait events
[QUOTE=thilamzn;28789]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.[/QUOTE]
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;