Oracle Streams 11g Data Replication

by Kirtikumar Deshpande

Overview

Master Oracle Streams 11g Replication

Enable real-time information access and data sharing across your distributed framework using the expert information in this Oracle Press guide. Oracle Streams 11g Data Replication explains how to set up and administer a unified enterprise data sharing infrastructure. Learn how to capture, propagate, and apply database changes, transform data, and handle data conflicts. Monitoring, optimizing, and troubleshooting techniques are also covered in this comprehensive volume.

• Understand Oracle Streams components and architecture
• Gain in-depth knowledge about capturing, propagating, and applying data manipulation language (DML) and data definition language (DDL) changes
• Learn how to access and modify the contents of Logical Change Records
• Build custom procedures for data transformations
• Configure Oracle Streams replication for the database, schemas, and tables
• Tune Oracle Streams performance for improved throughput
• Manage and monitor Oracle Streams using Oracle Enterprise Manager Grid Control
• Learn from several practical examples and scripts

Product Details

ISBN-13:	9780071759120
Publisher:	McGraw Hill LLC
Publication date:	12/22/2010
Series:	Oracle Press
Sold by:	Barnes & Noble
Format:	eBook
Pages:	576
File size:	7 MB

About the Author

Kirtikumar Deshpande currently works as a Senior Principal Consultant in the Advanced Technology Solutions group at Oracle Corporation. He has more than 28 years of experience in the Information Technology field, including more than 15 years with Oracle. He co-authored Oracle Performance Tuning 101 and Oracle Wait Interface: A Practical Guide to Performance Tuning & Diagnostics published by Oracle Press. For the latter, he and his co-authors were selected Oracle Magazine’s “Editors’ Choice Award – Author of The Year” in 2005. He is a frequent speaker at various Oracle User Group conferences worldwide.

Table of Contents

Part 1: Introduction to Oracle Streams
Chapter 1: What is Oracle Streams
Chapter 2: Using Oracle treams
Part 2: Oracle Streams Concepts and Architecture
Chapter 3: Streams Rules and Rule Sets
Chapter 4: Capture Process
Chapter 5: Staging and Propagation Process
Chapter 6: Apply Process
Chapter 7: Logical Change Records
Part 3: Oracle Streams Configuration
Chapter 8: Configuring Streams for Data Replication
Chapter 9: Data Transformations
Chapter 10: Handling Data Conflicts
Part 4: Oracle Streams Management
Chapter 11: Managing and Monitoring Streams Replication
Chapter 12: Maintenance and Troubleshooting
Chapter 13: Oracle Enterprise Manager 10g Grid Control
Chapter 14: Performance Considerations
Appendices
Appendix A: Best Practices for Streams Replication
Appendix B: Oracle Streams Replication in a RAC Environment
Appendix C: Helpful Views in Streams
Appendix D: Streams Health Check Report