Oracle SQL Tuning with Oracle SQLTXPLAIN et plus d'un million d'autres livres sont disponibles pour le Kindle d'Amazon. En savoir plus
EUR 35,82
  • Tous les prix incluent la TVA.
En stock.
Expédié et vendu par Amazon.
Emballage cadeau disponible.
Quantité :1
Oracle SQL Tuning with Or... a été ajouté à votre Panier
Amazon rachète votre
article EUR 11,25 en chèque-cadeau.
Vous l'avez déjà ?
Repliez vers l'arrière Repliez vers l'avant
Ecoutez Lecture en cours... Interrompu   Vous écoutez un extrait de l'édition audio Audible
En savoir plus
Voir les 2 images

Oracle SQL Tuning with Oracle SQLTXPLAIN (Anglais) Broché – 18 mars 2013


Voir les 3 formats et éditions Masquer les autres formats et éditions
Prix Amazon Neuf à partir de Occasion à partir de
Format Kindle
"Veuillez réessayer"
Broché
"Veuillez réessayer"
EUR 35,82
EUR 31,08 EUR 25,79

A court d'idées pour Noël ?

A court d'idées pour Noël ?
Découvrez dès aujourd'hui toutes nos Idées Cadeaux Livres. Vous trouverez sur nos étagères des milliers de livres disponibles pour combler ceux que vous aimez.

Offres spéciales et liens associés


Les clients ayant acheté cet article ont également acheté


Descriptions du produit

Présentation de l'éditeur

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


Vendez cet article - Prix de rachat jusqu'à EUR 11,25
Vendez Oracle SQL Tuning with Oracle SQLTXPLAIN contre un chèque-cadeau d'une valeur pouvant aller jusqu'à EUR 11,25, que vous pourrez ensuite utiliser sur tout le site Amazon.fr. Les valeurs de rachat peuvent varier (voir les critères d'éligibilité des produits). En savoir plus sur notre programme de reprise Amazon Rachète.

Détails sur le produit


En savoir plus sur l'auteur

Découvrez des livres, informez-vous sur les écrivains, lisez des blogs d'auteurs et bien plus encore.

Dans ce livre (En savoir plus)
Parcourir les pages échantillon
Couverture | Copyright | Table des matières | Extrait | Index
Rechercher dans ce livre:

Commentaires en ligne

Il n'y a pas encore de commentaires clients sur Amazon.fr
5 étoiles
4 étoiles
3 étoiles
2 étoiles
1 étoiles

Commentaires client les plus utiles sur Amazon.com (beta)

Amazon.com: 8 commentaires
5 internautes sur 5 ont trouvé ce commentaire utile 
Excellent for SQL tuning 2 juillet 2013
Par Corrado Piola - Publié sur Amazon.com
Format: Broché
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 internautes sur 5 ont trouvé ce commentaire utile 
Most Practical Book on Oracle SQL Tuning 28 mars 2013
Par James Killean - Publié sur Amazon.com
Format: Broché
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 internautes sur 4 ont trouvé ce commentaire utile 
Surprisingly good book 13 juillet 2013
Par Mladen Gogala - Publié sur Amazon.com
Format: Broché Achat vérifié
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!
4 internautes sur 4 ont trouvé ce commentaire utile 
Move From Knowledge To Understanding 28 mars 2013
Par Eric L. Yen - Publié sur Amazon.com
Format: Broché Achat vérifié
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 internautes sur 4 ont trouvé ce commentaire utile 
Best reference for Oracle SQL Tuning 14 juin 2013
Par Rockford Cogar - Publié sur Amazon.com
Format: Broché Achat vérifié
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.
Ces commentaires ont-ils été utiles ? Dites-le-nous


Commentaires

Souhaitez-vous compléter ou améliorer les informations sur ce produit ? Ou faire modifier les images?