Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> dbms_job polling interval

dbms_job polling interval

From: Sporge <RonGeorge_at_hotmail.com>
Date: 23 Aug 2004 04:09:02 -0700
Message-ID: <7e3b24c7.0408230309.54f17316@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 Mon Aug 23 2004 - 06:09:02 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US