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....

Descripción completa

Detalles Bibliográficos
Autor principal: Charalambides, Stelios. author (author)
Formato: Libro electrónico
Idioma:Inglés
Publicado: Berkeley, CA : Apress 2017.
Edición:2nd ed. 2017.
Colección:The expert's voice in Oracle
Materias:
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009630140606719
Tabla de Contenidos:
  • 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.