Oracle SQL Tuning with Oracle SQLTXPLAIN Oracle Database 12c Edition /

• Κύριος συγγραφέας: Charalambides, Stelios (Συγγραφέας)
• Συγγραφή απο Οργανισμό/Αρχή: SpringerLink (Online service)
• Μορφή: Ηλεκτρονική πηγή Ηλ. βιβλίο
• Γλώσσα: English
• Έκδοση: Berkeley, CA : Apress : Imprint: Apress, 2017.
• Έκδοση: 2nd ed.
• Θέματα: Computer science.; Database management.; Computer Science.; Database Management.

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

Πίνακας περιεχομένων:

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