Oracle SQL Tuning with Oracle SQLTXPLAIN

Stelios Charalambides has more than 20 years experience working with Oracle databases. He is OCP certified and has worked as a senior Consultant DBA on both sides of the Atlantic, dealing with all aspects of system design, implementation, and post production support, solving practical problems in a wide variety of environments. He now works as an Oracle Support Engineer developing time critical solutions for tier one customers with high profile performance problems.

1. Introduction to SQLTXPLAIN 2. The Cost-Based Optimizer Environment 3. How Object Statistics Can Make Your Execution Plan Wrong 4. How Skewness Can Make Your Execution Times Variable 5. Troubleshooting Query Transformations 6. Forcing Execution Plans Through Profiles 7. Adaptive Cursor Sharing 8. Dynamic Sampling and Cardinality Feedback 9. Using SQLTXPLAIN with Data Guard Physical Standby Databases 10. Comparing Execution Plans 11. Building Good Test Cases 12. Using XPLORE to Investigate Unexpected Plan Changes 13. Trace Files, TRCANLZR, and Modifying SQLT Behavior 14. Running a Health Check 15. The Final Word 16. Appendix A. Installing SQLTXPLAIN 17. Appendix B. The CBO Parameters (11.2.0.1) 18. Appendix C: Tool Configuration Parameters