Oracle Database 10g Performance Tuning Tips & Techniques and over 2 million other books are available for Amazon Kindle . Learn more

Sign in to turn on 1-Click ordering.
More Buying Choices
Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Image not available

Start reading Oracle Database 10g Performance Tuning Tips & Techniques on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Oracle Database 10g Performance Tuning Tips & Techniques (Oracle Press) [Paperback]

Richard Niemiec
3.0 out of 5 stars  See all reviews (3 customer reviews)
Price: 42.99 & FREE Delivery in the UK. Details
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Only 2 left in stock (more on the way).
Dispatched from and sold by Amazon. Gift-wrap available.
Want it tomorrow, 3 Aug.? Choose Express delivery at checkout. Details


Amazon Price New from Used from
Kindle Edition 36.01  
Paperback 42.99  
There is a newer edition of this item:
Oracle Database 11g Release 2 Performance Tuning Tips & Techniques (Oracle Press) Oracle Database 11g Release 2 Performance Tuning Tips & Techniques (Oracle Press) 4.0 out of 5 stars (1)
In stock.

Book Description

1 Aug 2007 0072263059 978-0072263053

"Offers hundreds of hints, tips, and tricks of the trade that can be useful to any DBA wanting to achieve maximum performance of Oracle applications. No Oracle library would be complete without this book." --Ken (Dr. DBA) Jacobs, Vice President of Product Strategy for Server Technologies, Oracle Corporation

"Rich is the first and last stop for Oracle Database technology and performance tuning. His knowledge is a vital tool that you need to successfully negotiate the waters of Oracle database development." --Mike Frey, Principal Architect, Navteq

Frequently Bought Together

Oracle Database 10g Performance Tuning Tips & Techniques (Oracle Press) + Oracle Database 11g Release 2 Performance Tuning Tips & Techniques (Oracle Press)
Buy the selected items together

Product details

  • Paperback: 967 pages
  • Publisher: McGraw-Hill Osborne (1 Aug 2007)
  • Language: English
  • ISBN-10: 0072263059
  • ISBN-13: 978-0072263053
  • Product Dimensions: 5 x 18.5 x 22.7 cm
  • Average Customer Review: 3.0 out of 5 stars  See all reviews (3 customer reviews)
  • Amazon Bestsellers Rank: 903,910 in Books (See Top 100 in Books)
  • See Complete Table of Contents

More About the Author

Discover books, learn about writers, and more.

Product Description

From the Back Cover

Maintain a High-Performance Oracle Database 10g Environment

Monitor, analyze, and optimize Oracle Database 10g using the tested methods and insider advice contained in this definitive volume. Written by Oracle Certified Master Richard Niemiec, Oracle Database 10g Performance Tuning Tips & Techniques is packed with detailed case studies, best practices, and code samples illustrating Oracle's new tuning features. Find out how to select optimal indexing options, effectively manage drives and disk arrays, troubleshoot queries, and reliably predict future performance. You'll also get detailed coverage of PL/SQL performance enhancements, initialization file tweaks, and the latest database surveying and reporting utilities.

"Rich does it again with a book that teaches to multiple levels in a bold and inspiring way." --Ari Kaplan, President, Independent Oracle Users Group

"There is no doubt about Rich's grasp on Oracle tuning and the way he simplifies intricate details in it." --Muhammad Shuja Uddin, Vice President and Head of Technical Support, Ora-Tech Systems; President, Pakistan Oracle Users Group

"Rich Niemiec is THE expert on Oracle tuning. This book is a ‘must have' for every Oracle DBA's bookshelf--there is something for everyone to learn. It is an excellent reference that proves useful over and over again." --Kimberly Floss, Manager, Database Services, PepsiCo; Former President, Independent Oracle Users Group

"Any book with Rich Niemiec as the author is a ‘must buy.' The man knows Oracle inside and out." --Karen Brownfield, Board of Directors, Oracle Applications Users Group



About the Author

Richard J. Niemiec is chief executive officer of TUSC, an Inc. 500 full-service consulting and training company specializing in Oracle technology. Rich has been named by Oracle Corporation as an Oracle Certified Master--one of only six originally so recognized around the world. He is the former president of the Independent Oracle Users Group (IOUG) and president of the Midwest Oracle Users Group. Rich has been named the Top Speaker of the IOUG Conference five times and is a member of the Entrepreneurial Hall of Fame.

Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Customer Reviews

5 star
3 star
2 star
3.0 out of 5 stars
3.0 out of 5 stars
Most Helpful Customer Reviews
31 of 33 people found the following review helpful
1.0 out of 5 stars Try before you buy 28 Sep 2007
Download chapter 14 ("Using Statspack and the AWR report to tune waits and latches") from McGraw-Hill before you buy the book. The last line reads: "Rich Niemiec upgraded this chapter from 9i to 10g (painful!)", so it seems reasonable to use this chapter to evaluate the book. Here are some examples of the issues I have with this chapter:

For the "Log Buffer Space" wait, we are told: "When a change is made, the changed block is copied to the log buffer" Wrong. A typical redo record contains the smallest possible description of the changes made to the targeted block and associated undo block - and even that's not an accurate statement in 10gR2, which introduced "private redo threads" (and related statistics) for small transactions.

Under "Enqueue" we see the statement: "while you no longer get TM locks, which are table locks when you don't index foreign keys, be sure to still index them to avoid a performance issue." Even in 10g you still get TM/4 (or 5) locks on child tables if you update or delete parent keys and haven't indexed the foreign key columns; but a change made in 9i means the locks get released, or down-converted, sooner. (So the indexing decision is application dependent.)

We are told that "Buffer Busy Waits" may be waits for a buffer that is `being read into the buffer cache' - but that event was renamed "read by other session" in 10g.

We are told that dbms_scheduler runs job gather_stats_job to take an AWR snapshot - but the AWR collection is controlled by the mmon background process; gather_stats_job handles database statistics.

There are sundry discussions of internal mechanisms that are simply wrong.
Read more ›
Comment | 
Was this review helpful to you?
0 of 1 people found the following review helpful
As a beginner DBA in most organizations, you're given mundane tasks like ensuring backups are successful, refreshing staging/test databases with production backups, looking through some GUI pages (eg OEM) to ensure no serious alerts are being flagged etc. But after some years as a beginner DBA, you're then required to be able to identify bottlenecks in the Database and resolve them and even contribute to future database architecture (sometimes even rubbing minds with Systems Engineers on hardware specs). This book was so vital for me during this transformation and I wouldn't have understood much in J. Lewis' book (Cost Based Oracle Fundamentals) without this book as it has a simple way of presenting complex topics. After reading this book, you can then move on to J. Lewis' book mentioned above, Tom Kyte's books (1.Effective Oracle by design 2.Expert Oracle database architecture) and Christian Antognini's 'Troubleshooting Oracle Performance...ofcourse and a host of other advanced books.
Comment | 
Was this review helpful to you?
0 of 1 people found the following review helpful
4.0 out of 5 stars A useful guide 11 Dec 2009
I'll confess to being an Oracle employee upfront but I don't have any vested interest in this or any other publication. I have however worked in the benchmarking and tuning arena for a number of years. Having read through the book (its not a light read) and I agree with some of Jonathan's points (he is the author of a number of books in this area and a subject matter expert). The main thrust of this book and the processes described in it are on the whole valid and I think it would a shame to loose sight of the useful information contained within. The subject is tackled in an easy to follow fashion without getting bogged down in detail that can some times offer little reward. Its not a bad book and I would recommend it to be used along side other similar reference books.

Reading this or any book in isolation won't make you an expert in this field. However its a start....
Comment | 
Was this review helpful to you?
Most Helpful Customer Reviews on (beta) 4.9 out of 5 stars  17 reviews
3 of 3 people found the following review helpful
5.0 out of 5 stars Fantastic Reference - Very Comprehensive! 2 Mar 2008
By Monica Penshorn - Published on
I highly recommend this book as a handy reference to keep at your desk. It is full of handy tips and a great assessment for reviewing your own environnment.
1 of 1 people found the following review helpful
4.0 out of 5 stars Very useful book 24 May 2009
By Antoni Grimalt Andreu - Published on
This is a very useful book for those who are looking for improving the performance of their Oracle Database. It's full of good tips that you can apply to your database.
Don't you expect miracles if you want this improving overnight. I've learned that tuning is an everyday (or every week) task.
1 of 1 people found the following review helpful
5.0 out of 5 stars Great book! 18 Nov 2008
By Paul Broenen, IntegriData, Inc. - Published on
Great book for Oracle database professionals who want to deepen their understanding of the manifold factors that affect performance. I learned a ton of instantly useful information during my first pass through the book. I now keep this book within arm's reach as a reference, using it frequently to address tuning issues as they arise.
1 of 1 people found the following review helpful
5.0 out of 5 stars For DBA and Developper 28 Mar 2008
By Guillaume Goulet-Vallieres - Published on

This book is great for DBA and Developper alike. I would recommend it to anyone working with Oracle, even if you're not working to solve performance issues. With all those tips at hand never your application will suffer from poor programming.

1 of 1 people found the following review helpful
5.0 out of 5 stars Good examples, a must read for any Oracle DBA 24 Feb 2008
By Alan Williams - Published on
Format:Paperback|Verified Purchase
I love reading this book. I typically read a few pages before bed. It's filled with lots of practical examples and suggestions. Very thorough explanations. Some of the examples could do with a little more explaining but overall it's still very useful.
Were these reviews helpful?   Let us know
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
First post:
Prompts for sign-in

Search Customer Discussions
Search all Amazon discussions

Look for similar items by category