dbms_job polling interval
From: Sporge <RonGeorge_at_hotmail.com>
Date: 23 Aug 2004 04:09:02 -0700
Message-ID: <7e3b24c7.0408230309.54f17316_at_posting.google.com>
Hi All
RedHat Linux 7.3 Received on Mon Aug 23 2004 - 13:09:02 CEST
Date: 23 Aug 2004 04:09:02 -0700
Message-ID: <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 Mon Aug 23 2004 - 13:09:02 CEST