Oracle Database 11g Release 2 Performance Tuning Tips & T... und über 1,5 Millionen weitere Bücher verfügbar für Amazon Kindle. Erfahren Sie mehr
  • Alle Preisangaben inkl. MwSt.
Nur noch 1 auf Lager
Verkauf und Versand durch Amazon.
Geschenkverpackung verfügbar.
Oracle Database 11g Relea... ist in Ihrem Einkaufwagen hinzugefügt worden
+ EUR 3,00 Versandkosten
Gebraucht: Sehr gut | Details
Verkauft von Erdmeier
Zustand: Gebraucht: Sehr gut
Kommentar: sofort verschickt im Luftpolsterumschlag incl.Rechnung mit Mwst.
Ihren Artikel jetzt
eintauschen und
EUR 6,45 Gutschein erhalten.
Möchten Sie verkaufen?
Zur Rückseite klappen Zur Vorderseite klappen
Anhören Wird wiedergegeben... Angehalten   Sie hören eine Probe der Audible-Audioausgabe.
Weitere Informationen
Alle 2 Bilder anzeigen

Oracle Database 11g Release 2 Performance Tuning Tips & Techniques (Oracle Press) (Englisch) Taschenbuch – 1. April 2012


Alle 2 Formate und Ausgaben anzeigen Andere Formate und Ausgaben ausblenden
Amazon-Preis Neu ab Gebraucht ab
Kindle Edition
"Bitte wiederholen"
Taschenbuch
"Bitte wiederholen"
EUR 39,95
EUR 35,29 EUR 28,99
58 neu ab EUR 35,29 8 gebraucht ab EUR 28,99

Hinweise und Aktionen

  • Große Hörbuch-Sommeraktion: Entdecken Sie unsere bunte Auswahl an reduzierten Hörbüchern für den Sommer. Hier klicken.


Wird oft zusammen gekauft

Oracle Database 11g Release 2 Performance Tuning Tips & Techniques (Oracle Press) + Advanced Oracle SQL Tuning: The Definitive Reference + Oracle Tuning: The Definitive Reference
Preis für alle drei: EUR 140,75

Die ausgewählten Artikel zusammen kaufen
Jeder kann Kindle Bücher lesen — selbst ohne ein Kindle-Gerät — mit der KOSTENFREIEN Kindle App für Smartphones, Tablets und Computer.


Große Hörbuch-Sommeraktion
Entdecken Sie unsere vielseitige Auswahl an reduzierten Hörbüchern aus den Bereichen Romane, Krimis & Thriller, Sachbuch und Kinder- & Jugendhörbücher. Klicken Sie hier, um direkt zur Aktion zu gelangen.

Produktinformation


Mehr über den Autor

Entdecken Sie Bücher, lesen Sie über Autoren und mehr

Produktbeschreibungen

Über den Autor und weitere Mitwirkende

Richard Niemiec is an Oracle Ace Director and one of only six originally honored Oracle Certified Masters worldwide. He was a co-founder and the CEO of TUSC, a Chicago-based systems integrator of Oracle-based business solutions. Rich currently serves as an Executive Advisor to Rolta International Board of Directors and has served as President of Rolta TUSC and Rolta EICT. TUSC was the Oracle Partner of the Year in 2002, 2004, 2007, 2008, and 2010 (Rolta TUSC). Rich is the past President of the International Oracle Users Group (IOUG) and the current President of the Midwest Oracle Users Group (MOUG). He is the bestselling author of Oracle Databasa 10g Performance Tuning Tips & Techniques, and he was inducted into the Entrepreneurship Hall of Fame in 1998.


In diesem Buch

(Mehr dazu)
Ausgewählte Seiten ansehen
Buchdeckel | Copyright | Inhaltsverzeichnis | Auszug | Stichwortverzeichnis
Hier reinlesen und suchen:

Kundenrezensionen

Es gibt noch keine Kundenrezensionen auf Amazon.de
5 Sterne
4 Sterne
3 Sterne
2 Sterne
1 Sterne

Die hilfreichsten Kundenrezensionen auf Amazon.com (beta)

Amazon.com: 26 Rezensionen
34 von 35 Kunden fanden die folgende Rezension hilfreich
Good but not perfect 13. Mai 2012
Von John Watson - Veröffentlicht auf Amazon.com
Format: Taschenbuch
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 von 16 Kunden fanden die folgende Rezension hilfreich
Comprehensive Guide for Developers and DBAs 4. März 2012
Von Robert Stackowiak - Veröffentlicht auf Amazon.com
Format: Taschenbuch
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 von 15 Kunden fanden die folgende Rezension hilfreich
Essential Tools for any Oracle Professional 6. März 2012
Von Ken N - Veröffentlicht auf Amazon.com
Format: Taschenbuch
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 von 15 Kunden fanden die folgende Rezension hilfreich
A Cookbook For Success 13. März 2012
Von Michael Anthony - Veröffentlicht auf Amazon.com
Format: Taschenbuch
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.
3 von 4 Kunden fanden die folgende Rezension hilfreich
Very Useful, But Needs Improvement 16. Oktober 2013
Von Justin - Veröffentlicht auf Amazon.com
Format: Taschenbuch Verifizierter Kauf
I'll start with the good: The book is very comprehensive, and it's evident that the author put a great deal of effort into writing it. A few of the chapters, individually, are worth the price of the book.

Unfortunately, the book is also filled with outdated advice, and statements I had considered flat-out wrong or at the very least ostensible. I actually kept track of these statements but eventually gave up because the list was growing too long; I bought the book to learn more about Oracle performance tuning, not to be a technical editor for it.

In the end, I would recommend this book be used to strengthen your performance tuning knowledge. Use it to supplement the excellent documentation that Oracle makes available free of charge (including the Performance Tuning Guide).
Waren diese Rezensionen hilfreich? Wir wollen von Ihnen hören.