||Oracle Replication Tips by Burleson
Updating Oracle Materialized View Data
is set to a value greater than 0. Setting the job_queue_process
will enable one or more different job scheduler threads. These threads
can and do run in parallel - set them carefully or there will be so much
parallel activity that the database is brought to its knees.
If the refresh fails for any reason, including problems with the
database link or the master database site, the job will log a
failure in the dba_jobs
column FAILURE and reattempt the refresh after a period of time.
Normally, a job will attempt to re-execute one minute after the
first failure, then two minutes after the second failure, four
minutes after the third failure, and so on until it reaches either
16 failures or the time reaches the refresh interval.
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
Get a Personal Oracle
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.