Front Matter....Pages i-xxiii
Introduction....Pages 1-19
AWR: Your Guide on What to Do Next....Pages 21-35
The Cost-Based Optimizer Environment....Pages 37-57
How Object Statistics Can Make Your Execution Plan Wrong....Pages 59-71
How Skewness Can Make Your Execution Times Variable....Pages 73-91
Collecting Good Oracle 12c Statistics....Pages 93-103
Tracing CBO Decisions, Hints, and Query Transformations Using 10053....Pages 105-129
Forcing Execution Plans through Profiles....Pages 131-146
Adaptive Cursor Sharing....Pages 147-164
How to Work with Adaptive Plans....Pages 165-173
Dynamic Statistics....Pages 175-189
Directives and Statistics Feedback....Pages 191-200
Parallel Execution....Pages 201-211
SQL Monitor Active Reports....Pages 213-229
Using SQLTXPLAIN with an Active Data Guard Environment....Pages 231-243
Building Good Test Cases....Pages 245-272
Using XPLORE to Investigate Unexpected Plan Changes....Pages 273-297
Trace Files, TRCANLZR, and Modifying SQLT Behavior....Pages 299-324
Comparing Execution Plans....Pages 325-339
Running a Health Check....Pages 341-360
The Final Word....Pages 361-365
Back Matter....Pages 367-409