Overview
Main description
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
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: Streams Performance Considerations
Chapter 14: Oracle Enterprise Manager Grid Control for Streams Replication
Appendixes
Appendix A: Oracle Streams Best Practices
Appendix B: Oracle Streams Replication in a RAC Environment
Appendix C: Streams Health Check Report
Appendix D: Data Dictionary Views for Streams Replication
Index
Author comments
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.
