Oracle Data Pump (expdp / impdp) is the go-to tool for logical exports and imports. With Oracle Database 19c, Data Pump got several new enhancements to improve flexibility, performance, and security. These changes are especially useful in cloud migrations, partitioned environments, and multi-tenant databases. In this article, we’ll go through each enhancement, explain what it […]
Understanding how two different execution plans differ is a critical skill for performance tuning. In Oracle 19c and 21c, the DBMS_XPLAN package has evolved to include built-in functions that let you compare plans directly: COMPARE_PLANS, COMPARE_CURSOR, and COMPARE_EXPLAIN. In this post, we will: Environment Setup First, create a test user and a simple table to […]
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 […]