SEARCH
Disclaimer: Authors have full rights over their works. Reproduction of any part of the content is prohibited without prior authorization.
BOOK ORACLE SQL TUNING WITH ORACLE SQLTXPLAIN
SUMMARY
-
Items Found: 19
- Chapter 1: Introduction to SQLTXPLAIN 1
- Chapter 2: The Cost-Based Optimizer Environment 17
- Chapter 3: How Object Statistics Can Make Your Execution Plan Wrong 39
- Chapter 4: How Skewness Can Make Your Execution Times Variable 53
- Chapter 5: Troubleshooting Query Transformations 71
- Chapter 6: Forcing Execution Plans Through Profiles 93
- Chapter 7: Adaptive Cursor Sharing 111
- Chapter 8: Dynamic Sampling and Cardinality Feedback 129
- Chapter 9: Using SQLTXPLAIN with Data Guard Physical Standby Databases 147
- Chapter 10: Comparing Execution Plans 163
- Chapter 11: Building Good Test Cases 177
- Chapter 12: Using XPLORE to Investigate Unexpected Plan Changes 205
- Chapter 13: Trace Files, TRCANLZR and Modifying SQLT behavior 231
- Chapter 14: Running a Health Check 255
- Chapter 15: The Final Word 281
- Appendix A: Installing SQLTXPLAIN 285
- Appendix B: The CBO Parameters (11.2.0.1) 295
- Appendix C: Tool Configuration Parameters 307
- Index 311
