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
Clasificación:Libro Electrónico
Autor principal: Charalambides, Stelios (Autor)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: [New York, NY] : Apress, [2017]
Edición:Second edition.
Colección:Expert's voice in Oracle.
Temas:
Oracle (Computer file)
SQL (Computer program language)
Database management.
Bases de données > Gestion.
SQL (Langage de programmation)
Databases.
COMPUTERS > Client-Server Computing.
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
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.

Ejemplares similares