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 start reading now with a free Kindle Reading App.

Deliver to your Kindle or other device


Try it free

Sample the beginning of this book for free

Deliver to your Kindle or other device

Anybody can read Kindle books—even without a Kindle device—with the FREE Kindle app for smartphones, tablets and computers.
Oracle SQL Tuning with Oracle SQLTXPLAIN

Oracle SQL Tuning with Oracle SQLTXPLAIN [Kindle Edition]

Stelios Charalambides
5.0 out of 5 stars  See all reviews (1 customer review)

Print List Price: £26.50
Kindle Price: £13.98 includes VAT* & free wireless delivery via Amazon Whispernet
You Save: £12.52 (47%)
* Unlike print books, digital books are subject to VAT.


Amazon Price New from Used from
Kindle Edition £13.98  
Paperback £26.50  
Kindle Summer Sale: Over 500 Books from £0.99
Have you seen the Kindle Summer Sale yet? Browse selected books from popular authors and debut novelists, including new releases and bestsellers. Learn more

Customers Who Bought This Item Also Bought

Product Description

Product Description

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.

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.

Product details

  • Format: Kindle Edition
  • File Size: 9108 KB
  • Print Length: 317 pages
  • Publisher: Apress; 1 edition (20 Mar 2013)
  • Sold by: Amazon Media EU S.à r.l.
  • Language: English
  • Text-to-Speech: Enabled
  • X-Ray:
  • Average Customer Review: 5.0 out of 5 stars  See all reviews (1 customer review)
  • Amazon Bestsellers Rank: #362,639 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
  •  Would you like to give feedback on images?

More About the Author

Discover books, learn about writers, and more.

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