Results 1 to 3 of 3

Thread: Oracle wait events

  1. #1
    Junior Member
    Join Date
    Apr 2008
    Answers
    1

    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.


  2. #2
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074

    Re: Oracle wait events

    Check from dba_jobs_running.


  3. #3
    Expert Member
    Join Date
    Apr 2007
    Answers
    500

    Re: Oracle wait events

    Quote Originally Posted by thilamzn View Post
    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;


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact