Blog

Latest articles, tutorials, and insights on Oracle Database and GoldenGate technologies.

ggutil: Modernizing Oracle GoldenGate Management with Go

Discover ggutil, a modern, open-source CLI tool for efficient, concurrent management of multiple Oracle GoldenGate (OGG) environments. Learn about its core features, Go-based architecture, and...
Read More

Discussion on Application Architecture Technologies for ADG, OGG, and Data Warehouse Systems at Bank

A survey on the application architecture technology, current status and disaster recovery requirements of a banking client's ADG, OGG and data warehouse system, a comparison...
Read More

Best Practices and Recommendations for RAC databases with SGA size over 100GB

The goal of this note is to provide best practices and recommendations to users of Oracle Real Application Clusters (RAC) databases using very large SGA...
Read More

Demystifying the OGG Checkpoint Mechanism: From CPE/CPR/CPT Files to Breakpoint Resume Principles

A comprehensive analysis of the OGG Checkpoint mechanism, including its file structure, breakpoint resume principles, and operational best practices.
Read More

Demystifying the OGG Trail File: From Binary Structure and Version Compatibility to Cross-Platform Migration Pitfalls

A detailed analysis of the OGG Trail File, including its binary structure, version compatibility, and cross-platform migration challenges.
Read More

Gathering Other Types of Statistics

Since the Cost Based Optimizer is now the only supported optimizer, all tables in the database need to have statistics, including all of the dictionary...
Read More

When Not to Gather Statistics

Although the optimizer needs accurate statistics to select an optimal plan, there are scenarios where gathering statistics can be difficult, too costly, or cannot be...
Read More

Classic vs. Integrated Extract: A Deep Dive into Oracle GoldenGate

A detailed comparison of Oracle GoldenGate's Classic Extract and Integrated Extract modes, highlighting their core differences and practical implications.
Read More

Gathering Statistics More Quickly

As data volumes grow and maintenance windows shrink, it is more important than ever to gather statistics in a timely manner. Oracle offers a variety...
Read More