Re: cause of "jobq slave wait"
From: David Fitzjarrell <oratune_at_yahoo.com>
Date: Sun, 19 Sep 2010 23:53:45 -0700 (PDT)
Message-ID: <994825.57997.qm_at_web65412.mail.ac4.yahoo.com>
Date: Sun, 19 Sep 2010 23:53:45 -0700 (PDT)
Message-ID: <994825.57997.qm_at_web65412.mail.ac4.yahoo.com>
This is an idle wait and is recorded for the job queue background processes, not
the foreground user processes.
When a job queue process is between jobs this wait timer starts. If there are
no more jobs to run this wait increases.
David Fitzjarrell
________________________________
From: Anupam Pandey <my.oralce_at_gmail.com>
To: oracle Freelists <oracle-l_at_freelists.org>
Cc: pandey83_at_gmail.com
Sent: Mon, September 20, 2010 1:27:12 AM
Subject: cause of "jobq slave wait"
Hi All,
In my 11gR2 db I see there quite a few wait events of name "jobq slave
wait" .
What causes these wait events and is there any way to avoid these events .
Thanks And Regards,
Anupam
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Sep 20 2010 - 01:53:45 CDT