In Oracle Database 19c, a powerful new feature arrives: Real-Time Statistics. Its main goal is to reduce the chance that the optimizer makes poor decisions because of stale statistics — especially in scenarios where data changes rapidly between scheduled statistics gathering cycles. Real-time statistics build on earlier features like online statistics gathering for bulk loads […]
In Oracle environments where DDL replication (i.e., replicating schema changes automatically) is not enabled, handling a DDL change like adding a column in a replicated environment requires coordination and care. If not done properly, it may lead to data inconsistency or replication failures. In this blog post, we walk through a safe procedure using GoldenGate […]
In mission-critical systems, downtime is not an option. Organizations demand continuous availability — even during platform upgrades. This is where a Zero Downtime Database Upgrade from Oracle 12c to 19c using Oracle GoldenGate becomes a strategic capability. In this post, we walk you through the full process to achieve an upgrade with minimal disruption. Why […]
In modern DBA practices, backup performance and efficiency are critical underpinnings of reliability and recovery SLAs. Oracle’s Block Change Tracking (BCT) feature exists to accelerate RMAN incremental backups by avoiding full datafile scans. In Oracle 19c, BCT continues to deliver value—and knowing how to enable, monitor, and disable it becomes essential for any serious DBA. […]