Title:
Oracle SQL Tuning with Oracle SQLTXPLAIN Oracle Database 12c Edition / by Stelios Charalambides.
Main Entry:
Charalambides, Stelios. author.
SpringerLink (Online service)
Publisher:
Apress : Imprint: Apress,
Publication Date:
2017.
Publication Place:
Berkeley, CA :
ISBN:
9781484224366
Subject:
Computer science.
Database management.
Computer science.
Database management.
Edition:
2nd ed.
Contents:
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.
Related Records:
Springer eBooks
Printed edition: 9781484224359
Cover Image:
Log in
Help
