Re: cause of "jobq slave wait"
- From: Jared Still <jkstill@xxxxxxxxx>
- To: oratune@xxxxxxxxx
- Date: Wed, 22 Sep 2010 13:50:04 -0700
On Sun, Sep 19, 2010 at 11:53 PM, David Fitzjarrell <oratune@xxxxxxxxx>wrote:
> 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.
>
>
These can of course be eliminated like so:
alter system set job_queue_processes=0;
;)
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com
Other related posts:
