Oracle SQL Tuning with Oracle SQLTXPLAIN

Oracle SQL Tuning with Oracle SQLTXPLAIN

Oracle Database 12c Edition

Charalambides, Stelios N.

APress

04/2017

408

Mole

Inglês

9781484224359

15 a 20 dias


Versão ebook 33,61 €

Tagline: Tuning the way Oracle's own experts do it
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 Plans11. Dynamic Statistics12. Directives and Statistics Feedback13. Parallel Execution14. 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 Check21. The Final Word22. Appendix A. Installing SQLTXPLAIN23. Appendix B. The CBO Parameters (11.2.0.1)24. Appendix C. Tool Configuration Parameters and the Express Methods
Este título pertence ao(s) assunto(s) indicados(s). Para ver outros títulos clique no assunto desejado.