Streaming Oracle CDC to Kafka with OGG for Big Data: A Configuration Guide
Learn how to use Oracle GoldenGate for Big Data with an end-to-end configuration guide to stream real-time Change Data Capture (CDC) from Oracle databases into...
Read More
ADG Standby Database Hung I/O
Standby instance 1 was accessible and could execute query SQL, but executing `alter database recover managed standby cancel;` had no response. tnsping cdbdg was normal....
Read More
PGA Memory Operation Wait Event Caused by Different Table Data Volumes
A SQL execution remained in ACTIVE state (the SQL contained CONNECT BY / regexp_substr) with wait time attributed to PGA memory operation.
Read More
Don't Let Replicat Abend Easily: Achieving Fine-Grained Error Handling with REPERROR
Say goodbye to the nightmare of frequent Replicat ABENDs. This article provides an in-depth explanation of the OGG REPERROR parameter, teaching you how to break...
Read More
How to change the host name from uppercase to lowercase in RAC environment
opatch lsinventory shows one node in uppercase (incorrect one) and the other node in lowercase (correct one)
Read More
Demystifying OGG BATCHSQL: The Underlying Logic from SQL Array Execution to Performance Tuning
A deep dive into the 'nuclear weapon' of OGG Replicat performance tuning—the BATCHSQL parameter. This article reveals its array execution principles, synergistic tuning strategies with...
Read More
High Library Cache Lock Waits During Concurrent Heavy Mixed PMOPs and DML on Several Partitioned Tables
High 'library cache lock' with 'library cache load lock' waits were seen when there were partition maintenance operations (PMOPs) with concurrent DML on the same...
Read More
ORACLE Database Backup and Recovery (Multi-Scenario)
Ensure the effectiveness of backups to prevent data loss caused by hardware failures, application logic errors, human operational mistakes, viruses, hacker attacks, etc.
Read More
Don’t Underestimate Data Pump: More Than a Mover, It’s the Key to OGG Architecture Optimization
Explore why Oracle GoldenGate’s Data Pump is far more than a simple data mover. Learn how it decouples, routes, and enhances OGG architectures for robustness,...
Read More