Re: dbms_job polling interval
From: Deven Saoji <devensaoji_at_gmail.com>
Date: 24 Aug 2004 03:48:56 -0700
Message-ID: <525cdf93.0408240248.4534539b_at_posting.google.com>
Date: 24 Aug 2004 03:48:56 -0700
Message-ID: <525cdf93.0408240248.4534539b_at_posting.google.com>
Hi Ron,
You can increase the polling interval by executing the following SP
DBMS_JOB.INTERVAL
How long does your current job takes for execution.
Regards
Deven Saoji
RonGeorge_at_hotmail.com (Sporge) wrote in message news:<7e3b24c7.0408230309.54f17316_at_posting.google.com>...
> Hi All
>
> Is there any way to decrease the polling interval that Oracle uses to
> determine if there are jobs pending in the job queue.
>
> It appears that it takes up to 5 seconds for a job to be executed
> after it has been submitted via DBMS_JOB.SUBMIT.
>
> If possible, would it adversely affect resources by decreasing this
> interval?
>
> Thanks
> Ron
>
> Oracle 9.2.0.4
> RedHat Linux 7.3
Received on Tue Aug 24 2004 - 12:48:56 CEST