2013

Oracle SQL Tuning with Oracle SQLTXPLAIN

Authors:

ISBN: 978-1-4302-4809-5 (Print) 978-1-4302-4810-1 (Online)

Table of contents (15 chapters)

  1. Front Matter

    Pages i-xxv

  2. No Access

    Book Chapter

    Pages 1-16

    Introduction to SQLTXPLAIN

  3. No Access

    Book Chapter

    Pages 17-37

    The Cost-Based Optimizer Environment

  4. No Access

    Book Chapter

    Pages 39-51

    How Object Statistics Can Make Your Execution Plan Wrong

  5. No Access

    Book Chapter

    Pages 53-69

    How Skewness Can Make Your Execution Times Variable

  6. No Access

    Book Chapter

    Pages 71-92

    Troubleshooting Query Transformations

  7. No Access

    Book Chapter

    Pages 93-109

    Forcing Execution Plans Through Profiles

  8. No Access

    Book Chapter

    Pages 111-128

    Adaptive Cursor Sharing

  9. No Access

    Book Chapter

    Pages 129-146

    Dynamic Sampling and Cardinality Feedback

  10. No Access

    Book Chapter

    Pages 147-162

    Using SQLTXPLAIN with Data Guard Physical Standby Databases

  11. No Access

    Book Chapter

    Pages 163-176

    Comparing Execution Plans

  12. No Access

    Book Chapter

    Pages 177-204

    Building Good Test Cases

  13. No Access

    Book Chapter

    Pages 205-230

    Using XPLORE to Investigate Unexpected Plan Changes

  14. No Access

    Book Chapter

    Pages 231-253

    Trace Files, TRCANLZR and Modifying SQLT behavior

  15. No Access

    Book Chapter

    Pages 255-280

    Running a Health Check

  16. No Access

    Book Chapter

    Pages 281-284

    The Final Word

  17. Back Matter

    Pages 285-317