undrgrnd Cliquez ici Toys NEWNEEEW nav-sa-clothing-shoes Cloud Drive Photos FIFA16 cliquez_ici Rentrée scolaire Shop Fire HD 6 Shop Kindle Paperwhite cliquez_ici Jeux Vidéo

Envoyer sur votre Kindle ou un autre appareil

 
 
 

Essai gratuit

Découvrez gratuitement un extrait de ce titre

Envoyer sur votre Kindle ou un autre appareil

Désolé, cet article n'est pas disponible en
Image non disponible pour la
couleur :
Image non disponible
 

Oracle Database 11g Release 2 Performance Tuning Tips & Techniques [Format Kindle]

Richard Niemiec
4.7 étoiles sur 5  Voir tous les commentaires (3 commentaires client)

Prix conseillé : EUR 57,44 De quoi s'agit-il ?
Prix Kindle : EUR 31,60 TTC & envoi gratuit via réseau sans fil par Amazon Whispernet
Économisez : EUR 25,84 (45%)

App de lecture Kindle gratuite Tout le monde peut lire les livres Kindle, même sans un appareil Kindle, grâce à l'appli Kindle GRATUITE pour les smartphones, les tablettes et les ordinateurs.

Pour obtenir l'appli gratuite, saisissez votre adresse e-mail ou numéro de téléphone mobile.

Formats

Prix Amazon Neuf à partir de Occasion à partir de
Format Kindle EUR 31,60  
Broché --  

Concours | Rentrée Kindle des auteurs indés - Participez au premier concours organisé par Kindle Direct Publishing et et saisissez votre chance de devenir le nouveau coup de cœur littéraire sur Amazon !



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

Cette fonction d'achat continuera à charger les articles. Pour naviguer hors de ce carrousel, veuillez utiliser votre touche de raccourci d'en-tête pour naviguer vers l'en-tête précédente ou suivante.

Descriptions du produit

Présentation de l'éditeur

Implement Proven Database Optimization Solutions

Systematically identify and eliminate database performance problems with help from Oracle Certified Master Richard Niemiec. Filled with real-world case studies and best practices, Oracle Database 11g Release 2 Performance Tuning Tips & Techniques details the latest monitoring, troubleshooting, and optimization methods. Find out how to find and fix bottlenecks, configure storage devices, execute effective queries, and develop bug-free SQL and PL/SQL code. Testing, reporting, and security enhancements are also covered in this Oracle Press guide.

  • Properly index and partition Oracle Database 11g Release 2
  • Work with Oracle Exadata and Oracle Exalogic Elastic Cloud
  • Efficiently manage disk drives, RAID arrays, and memory
  • Tune queries with Oracle SQL hints and the TRACE utility
  • Troubleshoot databases using V$ views and X$ tables
  • Distribute workload using Oracle Real Application Testing
  • Generate reports using Oracle's Statspack and Automatic Workload Repository tools
  • Use sar, vmstat, and iostat to monitor system statistics

“This is a timely update of Rich’s classic book on Oracle Database performance tuning to cover hot new topics like Oracle Database 11g Release 2 and Oracle Exadata. This is a must-have for DBAs moving to these new products.” --Andrew Mendelsohn, Senior Vice President, Oracle Database Server Technologies


Détails sur le produit

  • Format : Format Kindle
  • Taille du fichier : 32381 KB
  • Nombre de pages de l'édition imprimée : 1184 pages
  • Utilisation simultanée de l'appareil : Jusqu'à 4 appareils simultanés, selon les limites de l'éditeur
  • Editeur : McGraw-Hill Education; Édition : 1 (22 mars 2012)
  • Vendu par : Amazon Media EU S.à r.l.
  • Langue : Anglais
  • ASIN: B007O6PQCU
  • Synthèse vocale : Activée
  • X-Ray :
  • Word Wise: Non activé
  • Composition améliorée: Non activé
  • Moyenne des commentaires client : 4.7 étoiles sur 5  Voir tous les commentaires (3 commentaires client)
  • Classement des meilleures ventes d'Amazon: n°150.834 dans la Boutique Kindle (Voir le Top 100 dans la Boutique Kindle)
  •  Souhaitez-vous faire modifier les images ?


En savoir plus sur l'auteur

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

Commentaires en ligne

3 étoiles
0
2 étoiles
0
1 étoiles
0
4.7 étoiles sur 5
4.7 étoiles sur 5
Commentaires client les plus utiles
5.0 étoiles sur 5 le livre à avoir 18 juillet 2013
Par Exan
Format:Broché|Achat vérifié
alors ce libre est le livre des bonnes choses pour vous aider/apprendre les plus grands axes de recherches dans les optimisations de d base de données. Très bien écrit, un bon niveau d'informations et d'exemples que l'ont soit senior ou pas, ce livre est aussi bien un support qu'un enrichissement
Avez-vous trouvé ce commentaire utile ?
5.0 étoiles sur 5 Does Richard Niemiec need any comments 18 décembre 2012
Format:Format Kindle|Achat vérifié
As a DBA, I need from time to time some very precise input and Richard is very good at that.
He has understood what we need on the job and put it in a way it's a valuable repository of excellent receipts.
Thanks so much for that.
Avez-vous trouvé ce commentaire utile ?
4.0 étoiles sur 5 very practical book 28 novembre 2013
Par DSarr
Format:Broché|Achat vérifié
I recognize that this book is very practical.
It treats at the same time basics and more advanced issues.
Very well written book and covers the field of tuning oracle
This is to add to the library of the DBA.
Avez-vous trouvé ce commentaire utile ?
Commentaires client les plus utiles sur Amazon.com (beta)
Amazon.com: 4.5 étoiles sur 5  26 commentaires
34 internautes sur 35 ont trouvé ce commentaire utile 
4.0 étoiles sur 5 Good but not perfect 13 mai 2012
Par John Watson - Publié sur Amazon.com
Format:Broché
The book is aimed at "helping beginner and intermediate Oracle professionals" (page 2). Presumably that means knowledge equivalent to OCA or OCP qualifications. For the intended market it should be excellent, if (like me) you are OCM, you will learn not that much. But there are some issues.
The good stuff first: chapters 2 (indexes), 6 (explain plan), 7 (hints), 8 (query tuning), 9 (joins), 10 (pl/sql), 11 (parallelism only - ignore the stuff about Exa% and RAC, they can't be covered in just a few pages), 12 (v$ views) and 13 (x$ tables) are excellent and make the book worth the price. They get it the 4 star rating.
Some other chapters (and the 3 appendices) may be interesting, but they aren't essential reading: chapters 1 (new features), 5 (Enterprise Manager), 15 (a system review method), and 16 (some Unix commands).
Three remaining chapters are good, but have problems. Chapter 3 on discs and ASM does go on about placing files on different discs to eliminate contention. This is dreadfully old fashioned, and I assume has been copied from previous versions of the book. I hope everyone knows that best practice is to stripe all your file systems across all your discs. Chapter 4 (initialization parameters) is also out of date: it goes on about tuning with hit ratios, which is very 20th century. Chapter 14 (AWR and Statspack reports) is good as far as it goes, but it misses a critical topic: there is no mention of DB Time and v$sys_time_model, even though this is the first part of a report that many DBAs will go to.
Now the bad stuff. First, the technical editing is poor. All authors make mistakes (I certainly do) and the tech editors are meant to catch them. Just a few incontrovertible examples:
Page 4, the description of Exadata storage indexes is wrong, "...which cells need to be accessed..." should read "...which blocks need to be accessed..." Pages 21,22 include an example of code to set up a flashback data archive, which ends with a query that can't work because it projects a column that isn't in the table. On page 334, the first example can't work because the hint is missing the table name. There are many more like this, I'll send all the ones I spotted to McGraw-Hill for inclusion in the errata sheet. Things like this are not trivial, they can be confusing or misleading. Be sure to download the errata.
Second, the bad one: the author is wrong on how redo is generated. Page 147 gives a description of redo which suggests that only committed changes and changes to undo segments generate redo, but that uncommitted changes do not. Page 782 compounds the error by suggesting that redo is no longer written to disc in near-as-damnit real time (and of course it is real time on commit), and page 866 makes it even worse by saying that whole blocks (not change vectors) go to the log buffer (as in release 5, perhaps?). Related to this is the wrong description of the log_buffer parameter (page 204, repeated on 1004) which states that the log buffer is used for "uncommitted transactions in memory". It also says incorrectly that you cannot set the parameter in an spfile. Understanding redo is critical, and is why I chopped a point off the score.
So overall, the book is good, but read it with your eyes open.
15 internautes sur 16 ont trouvé ce commentaire utile 
5.0 étoiles sur 5 Comprehensive Guide for Developers and DBAs 4 mars 2012
Par Robert Stackowiak - Publié sur Amazon.com
Format:Broché
You'll find plenty of examples of techniques to use when tuning for Oracle Database 11g Release 2 performance, especially at the command line level. However, the book also does a credible job of providing examples of tuning using Enterprise Manager. It clearly lays out which chapters that will be especially relevant for DBAs, developers, or both, and at what level of expertise (from beginner to advanced). Exadata users will find a chapter devoted to this topic including the unique features available on that platform. This is a must have book for DBAs that want a single resource to go to when faced with a performance issue.
14 internautes sur 15 ont trouvé ce commentaire utile 
5.0 étoiles sur 5 Essential Tools for any Oracle Professional 6 mars 2012
Par Ken N - Publié sur Amazon.com
Format:Broché
This book is an essential tool that should be in every Oracle Professional's bookcase. It has value as a reference to fix performance issues that are currently present or as a study guide to take a beginner/intermediate DBA and/or Developer to an expert. Rich Niemiec brings performance tuning down from a mystical art down to a science with each topic covered concisely and thoroughly with clear instructions on how to implement them. Readers of previous versions of this book have a section that documents how each chapter has been updated. My favorite chapter is the one on Exadata as it really brought it home for me. It is a great tuning reference for developers, also it is one very few books cover the rare V$ views, X$ tables including how to query them.

I highly recommend this book especially for everyone looking to get the most out of their hardware. Why pay for new hardware when you can dramatically improve the performance of your current one using the information contained in this book?
11 internautes sur 15 ont trouvé ce commentaire utile 
5.0 étoiles sur 5 A Cookbook For Success 13 mars 2012
Par Michael Anthony - Publié sur Amazon.com
Format:Broché
This book is a must for every Oracle professional. It is full of information from the Intro which gives us a nice history of Oracle and the future ahead of us to the plethora of technical tips and techniques.

Richard Niemiec has always been a fantastic author and teacher; and continues to be with this book. It has over 1100 pages of useful tuning tips and techniques. Rich takes the time to provide real life examples and illustrations to guide us through solving the performance problem du jour.

In today's times with budgets being cut and time being so precious we may not be able to spend 3 - 5 days or several thousand dollars on a training class. If that's the case this book is well worth the price. And if you can afford the time and money to take a tuning class this book is a great tool to augment what you learn.

My recommendation is to use this book like a cookbook. Read the intro to get a sense where the author is coming from and then the first couple of chapters to get a feel for the book. Then every day or so read a different chapter; by the time you are done you will know what to do when a problem arises and more importantly what to do to prevent the problem in the first place. Like any good cookbook full of fantastic recipes that we all can follow this book will soon be dog eared, have notes in it and spills on it.

Another superb job by Richard Niemiec.
6 internautes sur 9 ont trouvé ce commentaire utile 
5.0 étoiles sur 5 A "must have" for any Oracle professional! 14 mars 2012
Par Joey Falupacheck - Publié sur Amazon.com
Format:Broché
As I look along my bookshelf I'm amazed at the number of authors who do now or have previously worked for TUSC. The books I always seem reach for first come largely from that group. This one, like the others, has already paid for itself several fold. I have found it to be an outstanding desk reference for day-to-day work and it packs great reading on the new features in 11gR2. It covers the basics as well as advanced topics in an easy to understand format.
The real key is that this book is clearly based on a lot of firsthand experience gained in the trenches in a wide variety of environments. It was written by a long time industry leader but not by him alone. In the "Acknowledgments" you see that he had help from some of the brightest in the field. That is what I feel sets it apart from others that read more like an academic review than a practical hands-on guide. There is simply no substitute for experience and this book is packed with it. This is a "must have" for any Oracle professional, regardless of your experience level.
Ces commentaires ont-ils été utiles ?   Dites-le-nous
Rechercher des commentaires

Discussions entre clients

Le forum concernant ce produit
Discussion Réponses Message le plus récent
Pas de discussions pour l'instant

Posez des questions, partagez votre opinion, gagnez en compréhension
Démarrer une nouvelle discussion
Thème:
Première publication:
Aller s'identifier
 

Rechercher parmi les discussions des clients
Rechercher dans toutes les discussions Amazon
   


Rechercher des articles similaires par rubrique