Oracle Database 11g Release 2 Performance Tuning Tips & T... and over one million other books are available for Amazon Kindle. Learn more

Oracle Database 11g Release 2 Performance Tuning Tips & Techniques (Oracle Press) 1st Edition

26 customer reviews
ISBN-13: 978-0071780261
ISBN-10: 0071780262
Why is ISBN important?
ISBN
This bar-code number lets you verify that you're getting exactly the right version or edition of a book. The 13-digit and 10-digit formats both work.
Scan an ISBN with your phone
Use the Amazon App to scan ISBNs and compare prices.
Sell yours for a Gift Card
We'll buy it for $8.41
Learn More
Trade in now
Have one to sell? Sell on Amazon
Try the eTextbook for free
$0.00
Buy used
$27.49
Buy new
$32.40
Amazon Price New from Used from
Kindle
"Please retry"
Paperback, February 27, 2012
"Please retry"
$32.40
$31.21 $21.00
More Buying Choices
30 New from $31.21 19 Used from $21.00
Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student


InterDesign Brand Store Awareness Textbooks
$32.40 FREE Shipping on orders over $35. Only 11 left in stock (more on the way). Ships from and sold by Amazon.com. Gift-wrap available.

Frequently Bought Together

Oracle Database 11g Release 2 Performance Tuning Tips & Techniques (Oracle Press) + Oracle Database 11g DBA Handbook (Oracle Press)
Price for both: $66.57

Buy the selected items together

Editorial Reviews

About the Author

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.

NO_CONTENT_IN_FEATURE


Shop the New Digital Design Bookstore
Check out the Digital Design Bookstore, a new hub for photographers, art directors, illustrators, web developers, and other creative individuals to find highly rated and highly relevant career resources. Shop books on web development and graphic design, or check out blog posts by authors and thought-leaders in the design industry. Shop now

Product Details

  • Series: Oracle Press
  • Paperback: 1140 pages
  • Publisher: Mcgraw-Hill Osborne Media; 1 edition (February 27, 2012)
  • Language: English
  • ISBN-10: 0071780262
  • ISBN-13: 978-0071780261
  • Product Dimensions: 8.3 x 2.3 x 8.9 inches
  • Shipping Weight: 4.1 pounds (View shipping rates and policies)
  • Average Customer Review: 4.5 out of 5 stars  See all reviews (26 customer reviews)
  • Amazon Best Sellers Rank: #306,923 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

34 of 35 people found the following review helpful By John Watson on May 13, 2012
Format: Paperback
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, "...
Read more ›
1 Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
15 of 16 people found the following review helpful By Robert Stackowiak on March 4, 2012
Format: Paperback
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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
14 of 15 people found the following review helpful By Ken N on March 5, 2012
Format: Paperback
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?
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
11 of 15 people found the following review helpful By Michael Anthony on March 13, 2012
Format: Paperback
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.
1 Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
6 of 9 people found the following review helpful By Joey Falupacheck on March 14, 2012
Format: Paperback
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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Most Recent Customer Reviews

Set up an Amazon Giveaway

Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more
Oracle Database 11g Release 2 Performance Tuning Tips & Techniques (Oracle Press)
This item: Oracle Database 11g Release 2 Performance Tuning Tips & Techniques (Oracle Press)
Price: $32.40
Ships from and sold by Amazon.com