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.

Prix Kindle : EUR 21,33

EUR 14,49 (40%)

TVA incluse

Ces promotions seront appliquées à cet article :

Certaines promotions sont cumulables avec d'autres offres promotionnelles, d'autres non. Pour en savoir plus, veuillez vous référer aux conditions générales de ces promotions.

Envoyer sur votre Kindle ou un autre appareil

Envoyer sur votre Kindle ou un autre appareil

Oracle SQL Tuning with Oracle SQLTXPLAIN par [Charalambides, Stelios]
Publicité sur l'appli Kindle

Oracle SQL Tuning with Oracle SQLTXPLAIN Format Kindle

Voir les formats et éditions Masquer les autres formats et éditions
Prix Amazon
Neuf à partir de Occasion à partir de
Format Kindle
"Veuillez réessayer"
EUR 21,33

Longueur : 332 pages Langue : Anglais

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.

Détails sur le produit

  • Format : Format Kindle
  • Taille du fichier : 9108 KB
  • Nombre de pages de l'édition imprimée : 332 pages
  • Pagination - ISBN de l'édition imprimée de référence : 1430248092
  • Editeur : Apress; Édition : 1 (19 mars 2013)
  • Vendu par : Amazon Media EU S.à r.l.
  • Langue : Anglais
  • ISBN-10: 1430248106
  • ISBN-13: 978-1430248101
  • Synthèse vocale : Activée
  • X-Ray :
  • Word Wise: Non activé
  • Composition améliorée: Non activé
  • Moyenne des commentaires client : Soyez la première personne à écrire un commentaire sur cet article
  • Classement des meilleures ventes d'Amazon: n°748.996 dans la Boutique Kindle (Voir le Top 100 dans la Boutique Kindle)
  •  Voulez-vous faire un commentaire sur des images ou nous signaler un prix inférieur ?

click to open popover

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) 4.8 étoiles sur 5 9 commentaires
8 internautes sur 8 ont trouvé ce commentaire utile 
5.0 é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 
5.0 é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 
5.0 é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 
5.0 é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 
5.0 é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