In earlier versions of Oracle Database, statistics were collected mainly through scheduled jobs using DBMS_STATS. This often resulted in stale statistics between collection intervals, especially in OLTP environments with frequent DML operations. Oracle 19c introduces Real-Time Statistics, a feature that collects optimizer statistics immediately during DML operations such as INSERT, UPDATE, MERGE, and CREATE TABLE […]
1. What is Conflict Detection and Resolution (CDR) in bidirectional replication? Conflict Detection and Resolution (CDR) is a mechanism in Oracle GoldenGate to handle data conflicts that arise in bidirectional (active-active) replication setups, where the same table is being updated at multiple sites simultaneously. 🧠Why is CDR needed? In active-active replication, changes can occur […]
Basic-Level Interview Questions 1. What is Oracle GoldenGate? Oracle GoldenGate is a real-time data replication and integration solution that enables transactional data to be moved across heterogeneous systems with minimal latency. It supports high-availability, zero-downtime migration, reporting offloading, and active-active database configurations. 2. What are the key components of Oracle GoldenGate architecture? The core components […]
Oracle Database 19c introduces a significant enhancement to the LISTAGG function by supporting the DISTINCT keyword directly within the aggregation clause. This simplifies query logic and improves readability when deduplicating values in aggregated string lists. Problem Statement The traditional LISTAGG function aggregates values into a delimited string but does not inherently remove duplicates, potentially leading […]