Cargando…
Pro Oracle GoldenGate for the DBA /
This book provides a simple approach to learning the Oracle GoldenGate product. This approach provides the in-depth perspective of GoldenGate from an implementer's viewpoint; however, also addresses why the management viewpoint is important as well. Your journey through this book includes and a...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
[New York, New York] :
Apress,
[2016]
|
| Colección: | Expert's voice in Oracle.
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
Tabla de Contenidos:
- At a Glance; Contents; About the Author; About the Technical Reviewer; Acknowledgments; Foreword; Chapter 1: Installation, Upgrade, and Removal; Selecting the Correct Version; Installing Oracle GoldenGate 12c; Creating Subdirectories; Viewing Inventory File Information; Upgrading Oracle GoldenGate; Removing Oracle GoldenGate; Oracle Universal Installer Deinstall Option; Hacking the oraInventory File; Summary; Chapter 2: Architecture; Architectures; Unidirectional Replication; Bidirectional (Active-Active) Replication; Real-Time Data Warehousing; Real-Time Data Distribution.
- Data Distribution via MessagingUnderstanding System Change Numbers; Finding the System Change Number in Oracle; GoldenGate Processes; Manager Process; Collector Process; Capture Process; Classic Capture; Integrated Capture; Data Pump Process; Delivery Process; Classic Delivery; Coordinated Delivery; Integrated Delivery; Trail Files; Summary; Chapter 3: Basic Replication Configuration; Profiler; Run Profiler; Parameter Files; Extract Parameter File; Data Pump Parameter File; Replicat Parameter File; Manager Parameter File; Trail Files; Sizing and Retention of Trail Files; Obey Files.
- Unidirectional ConfigurationPrerequisites; Enable Archive Log Mode; Enable Supplemental Logging; Enable Force Logging; Enable GoldenGate Parameter; Create a GoldenGate User; Granting Permissions to GoldenGate Users; Building Source GoldenGate Environment; Adding SCHEMATRANDATA or TRANDATA; SCHEMATRANDATA; TRANDATA; Edit Parameter Files; Starting the Extract; Extract (Data Pump) Process; Adding the Extract (Data Pump) Process; Starting the Data Pump (Extract) Process; Instantiation; Apply (Replicat) Process; Adding the Apply (Replicat) Process; Starting the Apply (Replicat) Process; Summary.
- Chapter 4: Tuning Oracle GoldenGateDifferent Types of Tuning; Classic Process Tuning; Tools for Tuning; GoldenGate Tools; Monitoring Latency or Lag Events; Reporting Transactional Statistics; Database Tools; Operating System Tools; Tuning the Classic Processes; Considerations When Using Multiple Process Groups; Maintaining Data Integrity; Number of Groups; Memory; Isolating Process-Intensive Tables; Using Parallel Replicat Groups on the Target System; Adding New Trails from the Extract; Source Steps; Target Steps; Network Tuning; Detecting Any Network Bottlenecks.
- Workaround for Bandwidth IssuesCompressing Data for Bandwidth Reduction; Increasing the TCP/IP Packet Sizes; Sizing TCP/IP Buffer Size; Eliminating Disk I/O Bottlenecks; Improving I/O Performance by System Configuration; Improving I/O Performance Within Oracle GoldenGate; Managing Virtual Memory and Paging; Applying Similar SQL Statements (Using Arrays); Full Table Scan Due to Absence of Keys; Tuning Integrated Processes; Tuning Tools for Integrated Processes; Automatic Workload Repository Output; Streams Performance Advisor; Installing Streams Performance Advisor.