By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,201 Members | 964 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,201 IT Pros & Developers. It's quick & easy.

dbms_job polling interval

P: n/a
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
Jul 19 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Ro*******@hotmail.com (Sporge) wrote in message news:<7e**************************@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

Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.