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
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 3 images

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

Voir les formats et éditions Masquer les autres formats et éditions
Prix Amazon
Neuf à partir de Occasion à partir de
Format Kindle
"Veuillez réessayer"
"Veuillez réessayer"
EUR 35,82
EUR 26,49 EUR 27,80
Note: Cet article est éligible à la livraison en points de collecte. Détails
Récupérer votre colis où vous voulez quand vous voulez.
  • Choisissez parmi 17 000 points de collecte en France
  • Les membres du programme Amazon Premium bénéficient de livraison gratuites illimitées
Comment commander vers un point de collecte ?
  1. Trouvez votre point de collecte et ajoutez-le à votre carnet d’adresses
  2. Sélectionnez cette adresse lors de votre commande
Plus d’informations
click to open popover

Offres spéciales et liens associés

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

Aucun appareil Kindle n'est requis. Téléchargez l'une des applis Kindle gratuites et commencez à lire les livres Kindle sur votre smartphone, tablette ou ordinateur.

  • Apple
  • Android
  • Windows Phone
  • Android

Pour obtenir l'appli gratuite, saisissez votre numéro de téléphone mobile.

Détails sur le produit

Commentaires en ligne

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

Commentaires client les plus utiles sur (beta) HASH(0x8bbda654) étoiles sur 5 9 commentaires
8 internautes sur 8 ont trouvé ce commentaire utile 
HASH(0x8b3fc120) étoiles sur 5 Excellent for SQL tuning 2 juillet 2013
Par Corrado Piola - Publié sur
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.
7 internautes sur 7 ont trouvé ce commentaire utile 
HASH(0x8b3fc174) étoiles sur 5 Most Practical Book on Oracle SQL Tuning 28 mars 2013
Par James Killean - Publié sur
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.
6 internautes sur 6 ont trouvé ce commentaire utile 
HASH(0x8b3fc5ac) étoiles sur 5 Surprisingly good book 13 juillet 2013
Par Mladen Gogala - Publié sur
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 
HASH(0x8b3fc594) étoiles sur 5 Move From Knowledge To Understanding 28 mars 2013
Par Eric L. Yen - Publié sur
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 
HASH(0x8b3fc960) étoiles sur 5 Best reference for Oracle SQL Tuning 14 juin 2013
Par Rockford Cogar - Publié sur
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


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