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

Книга "Oracle SQL Tuning with Oracle SQLTXPLAIN. Oracle Database 12c Edition". 1. Introduction2. AWR: Your Guide on What to do Next 3. The Cost-Based Optimizer Environment4. How Object Statistics Can Make Your Execution Plan Wrong 5. How Skewness Can Make Your Execution Times Variable 6. Collecting Good Oracle 12c Statistics7. Tracing CBO Decisions, Hints and Query Transformations using 10053 8. Forcing Execution Plans Through Profiles 9. Adaptive Cursor Sharing10. How To Work with Adaptive Plans11. Dynamic Statistics12. Directives and Statistics Feedback13. Parallel Execution14. SQL Monitor Active Reports15. Using SQLTXPLAIN with an Active Data Environment16. Building Good Test Cases17. Using XPLORE to Investigate Unexpected Plan Changes18. Trace Files, TRCANLZR and Modifying SQLT Behavior19. Comparing Execution Plans20. Running a Health Check21. The Final Word22. Appendix A. Installing SQLTXPLAIN23. Appendix B. The CBO Parameters ([link][link])24. Appendix C. Tool Configuration Pa...