Skip to main content
SpringerLink
Log in
Apress
Book cover

Oracle SQL Tuning with Oracle SQLTXPLAIN

  • Book
  • © 2013

Overview

Authors:
  1. Stelios Charalambides
    View author publications

    You can also search for this author in PubMed   Google Scholar

  • Oracle SQL Tuning with SQLTXPLAIN is a practical guide to SQL tuning the way Oracle's own experts do it, using a freely downloadable tool called SQLTXPLAIN.

  • 10k Accesses

This is a preview of subscription content, log in via an institution to check access.

Access this book

Log in via an institution
eBook USD 34.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever

Tax calculation will be finalised at checkout

Other ways to access

Licence this eBook for your library

Institutional subscriptions

Table of contents (15 chapters)

  1. Front Matter

    Pages i-xxv
    Download chapter PDF

  2. Introduction to SQLTXPLAIN

    • Stelios Charalambides
    Pages 1-16

  3. The Cost-Based Optimizer Environment

    • Stelios Charalambides
    Pages 17-37

  4. How Object Statistics Can Make Your Execution Plan Wrong

    • Stelios Charalambides
    Pages 39-51

  5. How Skewness Can Make Your Execution Times Variable

    • Stelios Charalambides
    Pages 53-69

  6. Troubleshooting Query Transformations

    • Stelios Charalambides
    Pages 71-92

  7. Forcing Execution Plans Through Profiles

    • Stelios Charalambides
    Pages 93-109

  8. Adaptive Cursor Sharing

    • Stelios Charalambides
    Pages 111-128

  9. Dynamic Sampling and Cardinality Feedback

    • Stelios Charalambides
    Pages 129-146

  10. Using SQLTXPLAIN with Data Guard Physical Standby Databases

    • Stelios Charalambides
    Pages 147-162

  11. Comparing Execution Plans

    • Stelios Charalambides
    Pages 163-176

  12. Building Good Test Cases

    • Stelios Charalambides
    Pages 177-204

  13. Using XPLORE to Investigate Unexpected Plan Changes

    • Stelios Charalambides
    Pages 205-230

  14. Trace Files, TRCANLZR and Modifying SQLT behavior

    • Stelios Charalambides
    Pages 231-253

  15. Running a Health Check

    • Stelios Charalambides
    Pages 255-280

  16. The Final Word

    • Stelios Charalambides
    Pages 281-284

  17. Back Matter

    Pages 285-317
    Download chapter PDF
Back to top

About this book

Oracle SQL Tuning with SQLTXPLAIN is a practical guide to SQL tuning the way Oracle's own experts do it, using a freely downloadable tool called SQLTXPLAIN. Using this simple tool you'll learn how to tune even the most complex SQL, and you'll learn to do it quickly, without the huge learning curve usually associated with tuning as a whole.

Firmly based in real world problems, this book helps you reclaim system resources and avoid the most common bottleneck in overall performance, badly tuned SQL. You'll learn how the optimizer works, how to take advantage of its latest features, and when it's better to turn them off.

  • Quickly tune any SQL statement no matter how complex.
  • Build and tune test cases without affecting production.
  • Use the latest tuning features with confidence.

About the author

Stelios Charalambides has more than 20 years experience working with Oracle databases. He is OCP certified and has worked as a senior Consultant DBA on both sides of the Atlantic, dealing with all aspects of system design, implementation, and post production support, solving practical problems in a wide variety of environments. He now works as an Oracle Support Engineer developing time critical solutions for tier one customers with high profile performance problems.

Bibliographic Information

Publish with us

Policies and ethics

Back to top

Search

Navigation