Login

Charalambides, Stelios

Oracle SQL Tuning with Oracle SQLTXPLAIN

Charalambides, Stelios - Oracle SQL Tuning with Oracle SQLTXPLAIN, ebook

50,75€

Ebook, PDF with Adobe DRM
ISBN: 9781484224366
DRM Restrictions

PrintingNot allowed
Copy to clipboardNot allowed

Table of contents

1. Introduction
Stelios Charalambides

2. AWR: Your Guide on What to Do Next
Stelios Charalambides

3. The Cost-Based Optimizer Environment
Stelios Charalambides

4. How Object Statistics Can Make Your Execution Plan Wrong
Stelios Charalambides

5. How Skewness Can Make Your Execution Times Variable
Stelios Charalambides

6. Collecting Good Oracle 12c Statistics
Stelios Charalambides

7. Tracing CBO Decisions, Hints, and Query Transformations Using 10053
Stelios Charalambides

8. Forcing Execution Plans through Profiles
Stelios Charalambides

9. Adaptive Cursor Sharing
Stelios Charalambides

10. How to Work with Adaptive Plans
Stelios Charalambides

11. Dynamic Statistics
Stelios Charalambides

12. Directives and Statistics Feedback
Stelios Charalambides

13. Parallel Execution
Stelios Charalambides

14. SQL Monitor Active Reports
Stelios Charalambides

15. Using SQLTXPLAIN with an Active Data Guard Environment
Stelios Charalambides

16. Building Good Test Cases
Stelios Charalambides

17. Using XPLORE to Investigate Unexpected Plan Changes
Stelios Charalambides

18. Trace Files, TRCANLZR, and Modifying SQLT Behavior
Stelios Charalambides

19. Comparing Execution Plans
Stelios Charalambides

20. Running a Health Check
Stelios Charalambides

21. The Final Word
Stelios Charalambides

Keywords: Computer Science, Database Management

Author(s)
Publisher
Springer
Publication year
2017
Language
en
Edition
2nd ed.
Page amount
23 pages
Category
Information Technology, Telecommunications
Format
Ebook
eISBN (PDF)
9781484224366
Printed ISBN
978-1-4842-2435-9

Similar titles