Logo - springer
Slogan - springer

Computer Science - Database Management & Information Retrieval | Oracle SQL Tuning with Oracle SQLTXPLAIN

Oracle SQL Tuning with Oracle SQLTXPLAIN

Charalambides, Stelios

2013, XXI, 344 p. 149 illus.

A product of Apress
Available Formats:

Springer eBooks may be purchased by end-customers only and are sold without copy protection (DRM free). Instead, all eBooks include personalized watermarks. This means you can read the Springer eBooks across numerous devices such as Laptops, eReaders, and tablets.

You can pay for Springer eBooks with Visa, Mastercard, American Express or Paypal.

After the purchase you can directly download the eBook file or read it online in our Springer eBook Reader. Furthermore your eBook will be stored in your MySpringer account. So you can always re-download your eBooks.


(net) price for USA

ISBN 978-1-4302-4810-1

digitally watermarked, no DRM

Included Format: PDF

download immediately after purchase

learn more about Springer eBooks

add to marked items


Softcover (also known as softback) version.

You can pay for Springer Books with Visa, Mastercard, American Express or Paypal.

Standard shipping is free of charge for individual customers.


(net) price for USA

ISBN 978-1-4302-4809-5

free shipping for individuals worldwide

usually dispatched within 3 to 5 business days

add to marked items

    • Covers the tool Oracle's own support engineers use to troubleshoot high-profile performance problems.
    • Strongly appeals to DBAs and developers who are often under great pressure to resolve problems swiftly.
    • Current with the very latest Oracle Database release - Oracle Database 12c.
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.

Content Level » Popular/general

Related subjects » Database Management & Information Retrieval

Table of contents 

    1. Introduction to SQLTXPLAIN

    2. The Cost-Based Optimizer Environment 

    3. How Object Statistics Can Make Your Execution Plan Wrong 

    4. How Skewness Can Make Your Execution Times Variable 

    5. Troubleshooting Query Transformations 

    6. Forcing Execution Plans Through Profiles 

    7. Adaptive Cursor Sharing

    8. Dynamic Sampling and Cardinality Feedback 

    9. Using SQLTXPLAIN with Data Guard Physical Standby Databases

    10. Comparing Execution Plans 

    11. Building Good Test Cases

    12. Using XPLORE to Investigate Unexpected Plan Changes 

    13. Trace Files, TRCANLZR, and Modifying SQLT Behavior 

    14. Running a Health Check 

    15. The Final Word

    16. Appendix A. Installing SQLTXPLAIN 

    17. Appendix B. The CBO Parameters (

    18. Appendix C: Tool Configuration Parameters

Popular Content within this publication 



Read this Book on Springerlink

Services for this book

New Book Alert

Get alerted on new Springer publications in the subject area of Database Management.