Oracle Replication Tips by Burleson

The Oracle replication Job Scheduler

change the job_queue_processes parameter to a value as low as 1 second.

Tip - job_queue_processes is a hidden parameter in Oracle9i, so it should be changed only as a last ditch solution to a problem, and with the consent of Oracle support.

One of the benefits of the job scheduler architecture is that it allows for the execution of parallel Oracle jobs, which can be a very powerful feature if used correctly. However, caution must be taken not to enable too many job queue processes as this can burden the system. We recommend that you enable no more than one job queue process per CPU.

A background process executes a job as the user that defined the job.  In other words, the process assumes the privileges of the user that created the job. The process will not have any privileges that the job creator does not possess. 

If the job executes successfully, it will be rescheduled according to the interval that was established when the job was created. For example, the interval may be defined as sysdate + 1, which would indicate that the next job execution should be scheduled to occur the next day.

If the job scheduler fails to execute a job, the failure is recorded. Failures continue to increment until 16 failures are reached. At that point, Oracle will break the job and suspend future executions. The DBA will then have to intervene to “unbreak” the job.

This is an excerpt from Oracle Replication By Rampant TechPress (only $19.95).  You can click here to order a copy and get instant access to the code depot:

http://www.rampant-books.com/book_2003_2_replication.htm

Get a Personal Oracle Replication Mentor

The author is now offering personal mentors for Oracle DBAs where you can have an Oracle expert right at your fingertips, anytime day or night. We work with hundreds of Oracle databases every year, so we know exactly how to quickly assist you with any Oracle replication question. 

You can get me personally, or any Oracle Certified replication DBA with more than 20 years of full-time IT experience.