Oracle SQL tuning with Oracle SQLTXPLAIN : Oracle database 12c edition /: Oracle database 12c edition. ([2017])

• Record Type: Book
• Further Information: Note: Stelios Charalambides.
• Authors: Charalambides, Stelios
• 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.
• Edition: Second edition
• Publisher Details: New York, NY : Apress
• Publication Date: 2017
• Copyright Date: 2017
• Extent: 1 online resource
• Subjects: 005.75/85; Computer science; SQL (Computer program language); Database management; COMPUTERS -- Client-Server Computing; Database management; SQL (Computer program language); Computers -- Database Management -- General; Databases; Electronic books
• Languages: English
• ISBNs: 9781484224366; 1484224361
• Related ISBNs: 9781484224359; 1484224353
• Notes: Note: Includes bibliographical references and index.; Note: Online resource; title from PDF title page (EBSCO, viewed April 12, 2017).
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.