Tuning Recipes
Tuning
Performance optimization recipes for Oracle — execution plans, statistics, hints, profiling, index management, and more.
Reading and Understanding Execution Plans
Learn to read EXPLAIN PLAN output and use DBMS_XPLAN to diagnose slow queries.
Learn more →Gathering and Managing Optimizer Statistics
Keep your statistics fresh to help the Cost-Based Optimizer make the right decisions.
Learn more →Using Optimizer Hints to Influence Execution Plans
Override the optimizer with hints for joins, indexes, parallel execution, and more.
Learn more →Better Performance by Having Less Data Type Conversions
Avoid unnecessary implicit and explicit data type conversions in PL/SQL for better performance.
Learn more →Statistical Data about Database Events, Waits and More Using ASH
Use Active Session History to analyze wait events and identify performance bottlenecks.
Learn more →Using DBMS_PROFILER to Find Bottleneck in a Procedure
Profile PL/SQL procedures line-by-line to identify the slowest parts of your code.
Learn more →Save Storage and Improve Performance by Compressing Your Indexes
Compress Oracle indexes to reduce storage and often improve query performance.
Learn more →Find Unnecessary Indexes
Identify indexes with low selectivity that may be wasting storage and slowing writes.
Learn more →Faster PL/SQL Code by Using Native Compiler
Switch from interpreted to native PL/SQL compilation for significant speed improvements.
Learn more →