Book Image

Oracle Goldengate 12c Implementers Guide

By : John P Jeffries
Book Image

Oracle Goldengate 12c Implementers Guide

By: John P Jeffries

Overview of this book

The book is aimed at Oracle database administrators, project managers, and solution architects who wish to extend their knowledge of GoldenGate. The reader is assumed to be familiar with Oracle databases. No knowledge of GoldenGate is required.
Table of Contents (16 chapters)
12
A. GGSCI Commands
13
B. GoldenGate Installed Components
14
C. Acronyms
15
Index

Chapter 5. Configuration Options

This chapter focuses on the additional configuration options available in Oracle GoldenGate 12c. The powerful options discussed here allow your configuration to extend in functionality and increase in performance. We will start with a performance enhancing option, enabling SQL statements to be grouped and applied as a batch against a target database. Later, we will explore the security features, including data compression and encryption, take a look at heterogeneous environments, and finally, discuss DDL support and the tools available to monitor the DDL replication.

This chapter explains the following configuration options:

  • Batching SQL by operation type
  • Data compression techniques
  • Data and password encryption methods
  • Using the Credential Store
  • Triggering an action from an event
  • Replicating DML statements to reduce lag during batch processing
  • The loop and conflict detection
  • The DDL replication
  • Using utilities to migrate Oracle Streams environment to GoldenGate...