dbms_job polling interval

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Sporge
    #1

    dbms_job polling interval

    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
    Tags: None
    • Deven Saoji
      #2
      Re: dbms_job polling interval

      Hi Ron,
      You can increase the polling interval by executing the following SP
      DBMS_JOB.INTERV AL
      How long does your current job takes for execution.


      Regards
      Deven Saoji

      RonGeorge@hotma il.com (Sporge) wrote in message news:<7e3b24c7. 0408230309.54f1 7316@posting.go ogle.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

        Comment

        Previous template Next
        Working...