Free Downloads
Oracle SQL Tuning With Oracle SQLTXPLAIN

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.

Paperback: 317 pages

Publisher: Apress; 1st ed. edition (March 19, 2013)

Language: English

ISBN-10: 1430248092

ISBN-13: 978-1430248095

Product Dimensions: 7.4 x 0.8 x 9.2 inches

Shipping Weight: 1.6 pounds (View shipping rates and policies)

Average Customer Review: 4.8 out of 5 stars  See all reviews (9 customer reviews)

Best Sellers Rank: #1,080,762 in Books (See Top 100 in Books) #264 in Books > Computers & Technology > Databases & Big Data > Oracle #514 in Books > Computers & Technology > Databases & Big Data > SQL #1105 in Books > Textbooks > Computer Science > Database Storage & Design

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.

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!

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.

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.

Bought the kindle version...I have had the pleasure to interact with Dr Stelios and his colleagues in support over the last several years on some pretty large Exadata databases, I go back to Oracle 4.x..and I found his SQLT offering to be a model of clarity on how to use this very powerful tool to arrive pretty quickly at the underlying causes of some of our performance issues.Well done ...thanks

SQL: Learn SQL In A DAY! - The Ultimate Crash Course to Learning the Basics of SQL In No Time (SQL, SQL Course, SQL Development, SQL Books, SQL for Beginners) Oracle SQL Tuning with Oracle SQLTXPLAIN SQL: QuickStart Guide - The Simplified Beginner's Guide To SQL (SQL, SQL Server, Structured Query Language) SQL: Beginner's Guide for Coding SQL (database programming, computer programming, how to program, sql for dummies, java, mysql, The Oracle, python, PHP, ... (HTML, Programming, Coding, CSS Book 7) Oracle PL/SQL Performance Tuning Tips & Techniques Oracle SQL Performance Tuning and Optimization: Its all about the Cardinalities Oracle SQL High-Performance Tuning (2nd Edition) Oracle Essbase & Oracle OLAP: The Guide to Oracle's Multidimensional Solution (Oracle Press) OCA Oracle Database 12c SQL Fundamentals I Exam Guide (Exam 1Z0-061) (Oracle Press) Oracle Database 11g SQL (Oracle Press) ORACLE PL/SQL 101 (Oracle Press) Advanced Tuning for JD Edwards EnterpriseOne Implementations (Oracle Press) Pro SQL Server 2012 BI Solutions (Expert's Voice in SQL Server) SQL: The Ultimate Beginners Guide: Learn SQL Today SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL (3rd Edition) Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions (Developer Reference) SQL Server 2012 Integration Services Design Patterns (Expert's Voice in SQL Server) SQL Queries for Mere Mortals(R): A Hands-On Guide to Data Manipulation in SQL Head First SQL: Your Brain on SQL -- A Learner's Guide SQL Handbook: Learning The Basics Of SQL Programming (Computer Science Programming) (Computer Programming For Beginners)