Oracle SQL Tuning with Oracle SQLTXPLAIN and over 2 million other books are available for Amazon Kindle . Learn more

Sign in to turn on 1-Click ordering.
Trade in Yours
For a 2.61 Gift Card
Trade in
More Buying Choices
Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Image not available

Start reading Oracle SQL Tuning with Oracle SQLTXPLAIN on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Oracle SQL Tuning with Oracle Sqltxplain [Paperback]

Stelios Charalambides
5.0 out of 5 stars  See all reviews (1 customer review)
Price: 26.50 & FREE Delivery in the UK. Details
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In stock.
Dispatched from and sold by Amazon. Gift-wrap available.
Want it Sunday, 27 July? Choose Express delivery at checkout. Details


Amazon Price New from Used from
Kindle Edition 13.98  
Paperback 26.50  
Trade In this Item for up to 2.61
Trade in Oracle SQL Tuning with Oracle Sqltxplain for an Amazon Gift Card of up to 2.61, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Learn more

Book Description

20 Mar 2013 1430248092 978-1430248095 1st New edition
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. What you'll learn How and why complex SQL goes wrong When statistics are crucial and when they are not How and when the tuning facilities of the database can help or hinder When to tune and when not to tune Which steps in an execution plan are crucial to performance How the optimizer works out the execution plan Who this book is for Oracle SQL Tuning with SQLTXPLAIN is ideal for everyone who deals with SQL and SQL tuning. Both developers and DBA's will benefit from learning how to use the SQLTXPLAIN tool along with the problem solving approach described in this book. 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

Frequently Bought Together

Oracle SQL Tuning with Oracle Sqltxplain + Expert Indexing in Oracle Database 11g: Maximum Performance for Your Database (Expert's Voice in Oracle) + Oracle Database 11g Performance Tuning Recipes: A Problem-Solution Approach (Expert's Voice in Oracle)
Price For All Three: 106.89

Buy the selected items together

Product details

  • Paperback: 344 pages
  • Publisher: Apress; 1st New edition edition (20 Mar 2013)
  • Language: English
  • ISBN-10: 1430248092
  • ISBN-13: 978-1430248095
  • Product Dimensions: 23.5 x 19 x 1.8 cm
  • Average Customer Review: 5.0 out of 5 stars  See all reviews (1 customer review)
  • Amazon Bestsellers Rank: 653,531 in Books (See Top 100 in Books)
  • See Complete Table of Contents

More About the Author

Discover books, learn about writers, and more.

Product Description

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.

Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index
Search inside this book:

What Other Items Do Customers Buy After Viewing This Item?

Customer Reviews

4 star
3 star
2 star
1 star
5.0 out of 5 stars
5.0 out of 5 stars
Most Helpful Customer Reviews
5.0 out of 5 stars Excellent primer on using SQLT 30 Dec 2013
If you're an oracle dba you may have come across SQLT via oracle support for tuning sql queries (MOS Doc Id: 215187.1). This book is a practical guide in installing and using the tool with worked through examples. I found it more accessible than the documentation provided with the utility itself.
Comment | 
Was this review helpful to you?
Most Helpful Customer Reviews on (beta) 4.9 out of 5 stars  8 reviews
5 of 5 people found the following review helpful
5.0 out of 5 stars Excellent for SQL tuning 2 July 2013
By Corrado Piola - Published on
This is a really good work. I suggest this reading to every Oracle professional, and not only to SQLT end users.
Interesting chapters show you how you can approach a SQL tuning methodology, and what you need to know about the Cost Based Optimizer.
I like so much the chapters about Adaptive Cursor Sharing, Dynamic Sampling and Cardinality Feedback.
If you don't want to install SQLT in your DB environment, the author shows you how you can use Oracle SQL Health Check.
SQLT and SQLHC are two good SQL tuning tools, both free of charge (if you have a MOS account), but pay attention to specify if you have licensed the extra-cost Diagnostic Pack, Tuning Pack or none of them.
I think this is one of the most interesting releases, about Oracle Database tuning, in the last few years.
5 of 5 people found the following review helpful
5.0 out of 5 stars Most Practical Book on Oracle SQL Tuning 28 Mar 2013
By James Killean - Published on
I love the practical approach in this book. You can tell that the author has worked as a DBA and understands the problems involved, as well as how to fix them. Many books on tuning seem intent on expounding theory. You get the feeling that the authors are very clever, but they don't give you anything you can put to immediate use. This book is different.

The explanations are clear, even funny in places and the information is practical. Like many I had no idea what SQLT was, but a friend recommended the book because he knew the author and I'm glad he did. Now I have a new tool and thanks to this book, I know how to use it.
4 of 4 people found the following review helpful
5.0 out of 5 stars Move From Knowledge To Understanding 28 Mar 2013
By Eric L. Yen - Published on
Format:Paperback|Verified Purchase
Many of us know SQL. Now move on to UNDERSTANDING the how and the why of SQL performance using SQLT. Stelios presents the material in a clear and concise manner. The style of the book is practical and can be put to use immediately. This book is different by removing the technical jargon and uses plain everyday vocabulary to help you gain a practical and thorough understanding of SQLT.

The linage of the understanding and experience is from Carlos Sierra (the father of SQLT) to Stelios. Be the next person in the linage . . . make it Carlos Sierra -> Stelios Charalambides -> You.
3 of 3 people found the following review helpful
5.0 out of 5 stars Surprisingly good book 13 July 2013
By Mladen Gogala - Published on
Format:Paperback|Verified Purchase
I bought this book fully intending to rip it to shreds both here and on my blog. After all, the tool is extremely simple to use: installation goes in a breeze, and then one can generate HTML reports with XTRACT or XECUTE and that's about it. The tool produces very detailed report that is easy to read. I didn't see a possibility to write a book about the SQLT tool. The author has, however, turned it into a surprisingly good general tuning book which uses the tool to explain the concepts like histograms, system statistics, SQL transformations and many more topics. I was pleasantly surprised and I will end up recommending this book. Good job!
3 of 4 people found the following review helpful
5.0 out of 5 stars Best reference for Oracle SQL Tuning 14 Jun 2013
By Rockford Cogar - Published on
Format:Paperback|Verified Purchase
Best reference for Oracle SQL Tuning, that's from a guy who does Oracle Perf/Tune full time. Chapter on data skewness is best I have read.
Were these reviews helpful?   Let us know
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
First post:
Prompts for sign-in

Search Customer Discussions
Search all Amazon discussions

Look for similar items by category