Oracle 19c strengthens the enterprise data management landscape by enabling online merging of adjacent table partitions—a refined capability that blends operational continuity with intelligent storage optimization. As organizations scale and data volume intensifies, the ability to reshape partition strategies without downtime becomes a cornerstone of performance engineering. Oracle’s online partition merge elevates this vision by […]
Oracle 19c elevates database intelligence by enabling Automatic Indexing by default, empowering DBAs and architects to achieve optimal performance without manual intervention. This strategic capability transforms the database into a self-managing ecosystem where indexing decisions are continuously evaluated, implemented, and refined based on real workload patterns. Automatic Indexing monitors SQL statements, identifies performance bottlenecks, and […]
Automatic Database Diagnostic Monitor (ADDM) analysis is now available for pluggable databases (PDBs) in Oracle 19c. ADDM at the PDB level enables targeted performance analysis and tuning for individual PDBs in a multitenant environment. The instructions below explain how ADDM works for PDBs, the required configuration steps to enable PDB-level ADDM, the important restrictions to […]
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 […]