Logga in

Charalambides, Stelios

Oracle SQL Tuning with Oracle SQLTXPLAIN

Charalambides, Stelios - Oracle SQL Tuning with Oracle SQLTXPLAIN, e-bok

45,00€

E-bok, PDF, Adobe DRM-skydd
ISBN: 9781484224366
DRM-begränsningar

Skriva utInte tillåtet
Kopiera till urklippInte tillåtet

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

Nyckelord: Computer Science, Database Management

Författare
Utgivare
Springer
Utgivningsår
2017
Språk
en
Utgåva
2nd ed.
Sidantal
23 sidor
Kategori
Datateknik, Datakommunikation
Format
E-bok
eISBN (PDF)
9781484224366
Tryckt ISBN
978-1-4842-2435-9

Liknande e-böcker