Logga in

Charalambides, Stelios

Oracle SQL Tuning with Oracle SQLTXPLAIN

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

32,15€

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

Skriva utInte tillåtet
Kopiera till urklippInte tillåtet

Table of contents

1. Introduction to SQLTXPLAIN
Stelios Charalambides

2. The Cost-Based Optimizer Environment
Stelios Charalambides

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

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

5. Troubleshooting Query Transformations
Stelios Charalambides

6. Forcing Execution Plans Through Profiles
Stelios Charalambides

7. Adaptive Cursor Sharing
Stelios Charalambides

8. Dynamic Sampling and Cardinality Feedback
Stelios Charalambides

9. Using SQLTXPLAIN with Data Guard Physical Standby Databases
Stelios Charalambides

10. Comparing Execution Plans
Stelios Charalambides

11. Building Good Test Cases
Stelios Charalambides

12. Using XPLORE to Investigate Unexpected Plan Changes
Stelios Charalambides

13. Trace Files, TRCANLZR and Modifying SQLT behavior
Stelios Charalambides

14. Running a Health Check
Stelios Charalambides

15. The Final Word
Stelios Charalambides

Nyckelord: Computer Science, Database Management

Författare
Utgivare
Springer
Utgivningsår
2013
Språk
en
Utgåva
1
Sidantal
342 sidor
Kategori
Datateknik, Datakommunikation
Format
E-bok
eISBN (PDF)
9781430248101

Liknande e-böcker