Oracle Training Oracle Support Development Oracle Apps

 E-mail Us
 Oracle Articles
New Oracle Articles

 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog

 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Oracle Support

 SQL Tuning

 Oracle UNIX
 Oracle Linux
 Remote s
 Remote plans
 Application Server

 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S


 Consulting Staff
 Consulting Prices
 Help Wanted!


 Oracle Posters
 Oracle Books

 Oracle Scripts

Don Burleson Blog 







Oracle Snapshot Replication & Streams Training Class

2007-2016 by Burleson Corporation



This course is taught at your Company site with up to 20 students. 

Click here for on-site course prices

Optional supplemental mentoring


Key Features

* Learn the internal mechanisms of Oracle snapshot refreshing.

* Understand how to leverage Oracle multimaster replication.

* See the underlying Oracle views for monitoring replication and streams.

* Learn the architecture of Oracle multimaster replication and Oracle Streams in simple terms with illustrative examples.

* Create working examples of snapshot creation, refresh, and error detection scripts.

* Understand details real-world techniques for implement conflict resolution in multi-master replication.

* Understand the successful installation and configuration techniques, reliable failover database, and subscribed destinations.


Course Description

Unlike some mediocre Oracle replication training, this course examines all Oracle distributed database and replication features with an eye on those features that are the most important to you.

This Oracle replication training is special because this course is taught by a veteran Oracle Certified DBA with more than 20 years of full-time experience.  This Oracle replication class can also be customized according to your specific needs.

Book Required


This course is designed for practicing Oracle professionals who have basic experience with Oracle. Prior experience with Oracle is not required, but experience using Oracle database is highly desirable.


Curriculum Design

This course was designed by Donald K. Burleson, an acknowledged leader in Oracle database administration.  Author of more than 30 database books, Burleson was chosen by Oracle Press to write five authorized editions, including Oracle High-Performance SQL tuning.  Burleson Corporation instructors offer decades of real world DBA experience in Oracle features, and they will share their secrets in this intense Oracle training.  Burleson also served as the Editor for the premier book Oracle10g New Features for the DBA by Rampant TechPress.

Oracle Snapshot Replication & Streams Training
3-Day Syllabus

Copyright 2007-2016 by Donald K. Burleson


Introduction to the Oracle Replication Architecture   
The Oracle Replication Architecture  
Database links
Basics of distributed updates
Inside the two-phase commit
Basics of Snapshot and Multi-master Replication  
Manual Replication techniques  
Installing Oracle Advanced Replication  

Overview of the replication packages
Checklist for installing advanced replication
  •    Creating the users
  •    Setting Oracle parameters
  •    Creating database links
  •    Managing replication security
  •    Testing replication
Basic read-only Replication with snapshots  

Read-Only Snapshot architecture
Restrictions of read-only snapshots  
Snapshot Creation Basics  
Setting the refresh interval
Complex Snapshot creation  
Creating and managing snapshot logs  
Subquery Sub-setting in snapshots  
Refresh Groups for snapshots
Using Oracle Updateable Snapshots  

Background in updateable snapshots  
Defining Updateable Snapshots  
Defining refresh intervals  



Using Updateable Materialized Views
Defining updatable materialized views
Monitoring Oracle Replication with Scripts

Goals of monitoring replication
Scripts to measure pending updates
Auto-correct script for broken snapshots

Using Oracle Procedural Replication  

Introduction to procedural replication
Installing the replication packages  
Restrictions on Procedural Replication  
Oracle Multi-Master Replication  

Background on multi-master replication
Restriction & limitations of multi-master replication
Using the Oracle-supplied packages
Defining Replication Groups  
Defining the master site
Defining propagation rules  
Using  the dbms_repcat package
Replication of data definitions (DDL)  
Conflict Avoidance in multi-master replication  

The causes of data conflicts
The options for conflict resolution
Using Referential Integrity with multi-master replication
Techniques to avoid data conflicts
Implementing an automated conflict avoidance mechanism
Manual intervention and conflict detection



Introduction to Oracle Streams

Data Sharing

• Growing Need
• Global Operations
• Heterogeneous Systems

Data Synchronization

• Data Movement
• Data Transformation
• Data Migration
• Data Replication

What is Oracle Streams?

Why Oracle Streams?

Where to use Streams Mechanism
• Replication
• AQ – Advanced Queuing
• Event Management
• Data Loading
• Summarization of Data
• High Availability and Disaster Recovery

Streams Historical Growth
• Advanced Replication
• Advanced Queuing

Related Oracle Technologies
• Log Miner
• Standby – Data Guard

Peer Products
• Sybase Replication
• Quest Shareplex
• GoldenGate
• Data Mirror

Streams Components and Processes

Producer and Consumer
LCR Object

• Row LCR
• Additional Attributes

Hot Mining and Cold Mining
Log based Changes
Capture Process
Propagation of Changes
Apply Process
Queuing and Dequeuing

Rules and Rules Engine
• Application of Rules
• Transformation
• Contexts

Streams Tags

Directed Network
DownStreams Capture
Change Data Capture
Supplemental Logging
Sys.Anydata Object
DML Handlers

Streams Replication

• Database Changes
• User Application Message

Destination Database
Data Types for Replication

• Rule Set
• Capture Rules
• Propagation Rules
• Apply Rules
• Contexts
• Transformations


• Capture process for Instantiation
• Oracle Data Pump for Instantiation
• Export and Import for Instantiation

The Role of Streams Tags

• How to create
• Utility of Tags
• Tags for Apply Process


This is a BC Oracle training course (c) 2007-2016



Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


Copyright © 1996 -  2017

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.

Remote Emergency Support provided by Conversational