Oracle Replication Tips by Burleson

Oracle replication monitoring

Monitoring is a hallmark operation for any mission-critical enterprise database. Since replication is an important part of the overall enterprise data distribution schema, we must monitor replication operations carefully and be aware of any problems that may occur.

Our first stop in this chapter will be the job scheduler. Both one-way replication and updatable materialized views rely on the database job scheduler to execute jobs that refresh the materialized views. Next, we will discuss methods to monitor the replication job processes to ensure that replication continues to function, or if problems are encountered, to generate an alert to notify the administrator that intervention is required.

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.