||Oracle Replication Tips by Burleson
Oracle Materialized View refresh dba_jobs dbms_job
If the refresh interval is every two minutes, the job will reattempt to
execute one minute after the first failure and will reattempt to execute
every two minutes after that until it reaches 16 failures. When a job
reaches 16 failures, it marks itself as broken (as seen in the BROKEN
column of dba_jobs)
and makes no further attempt to execute. Once a job successfully
executes, it resets its number of failures to zero.
If a job becomes broken, you must first fix whatever the problem is,
and then use the dbms_job.broken procedure to reset the job to
active status. You can tell if a replication job is operating by
looking at the
view. This view provides a list of all currently executing jobs.
You can manually refresh an Materialized View
via the dbms_refresh.refresh procedure. Here is an example of
refreshing our employee’s Materialized View:
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.