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 […]
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 […]