Oracle SQL Tuning with Oracle SQLTXPLAIN Oracle Database 12c Edition
Learn through this practical guide to SQL tuning how Oracle's own experts do it, using a freely downloadable tool called SQLTXPLAIN. This new edition has been expanded to include AWR, Oracle 12c Statistics, interpretation of SQL Monitor reports, Parallel execution, and Exadata-related features....
| Main Author: | |
|---|---|
| Format: | eBook |
| Language: | English |
| Published: |
Berkeley, CA
Apress
2017, 2017
|
| Edition: | 2nd ed. 2017 |
| Subjects: | |
| Online Access: | |
| Collection: | Springer eBooks 2005- - Collection details see MPG.ReNa |
Table of Contents:
- 1. Introduction
- 2. AWR: Your Guide on What to do Next
- 3. The Cost-Based Optimizer Environment
- 4. How Object Statistics Can Make Your Execution Plan Wrong
- 5. How Skewness Can Make Your Execution Times Variable
- 6. Collecting Good Oracle 12c Statistics
- 7. Tracing CBO Decisions, Hints and Query Transformations using 10053
- 8. Forcing Execution Plans Through Profiles
- 9. Adaptive Cursor Sharing
- 10. How To Work with Adaptive Plans
- 11. Dynamic Statistics
- 12. Directives and Statistics Feedback
- 13. Parallel Execution
- 14. SQL Monitor Active Reports
- 15. Using SQLTXPLAIN with an Active Data Environment
- 16. Building Good Test Cases
- 17. Using XPLORE to Investigate Unexpected Plan Changes
- 18. Trace Files, TRCANLZR and Modifying SQLT Behavior
- 19. Comparing Execution Plans
- 20. Running a Health Check
- 21. The Final Word
- 22. Appendix A. Installing SQLTXPLAIN
- 23. Appendix B. The CBO Parameters (11.2.0.1)
- 24. Appendix C. Tool Configuration Parameters and the Express Methods