Enter your mobile number below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
Getting the download link through email is temporarily not available. Please check back later.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your mobile phone number.

Kindle Price: £37.52

Save £13.47 (26%)

includes VAT*
* Unlike print books, digital books are subject to VAT.

These promotions will be applied to this item:

Some promotions may be combined; others are not eligible to be combined with other offers. For details, please see the Terms & Conditions associated with these promotions.

Deliver to your Kindle or other device

Deliver to your Kindle or other device

Oracle Database 10g Performance Tuning Tips & Techniques (Oracle Press) by [Niemiec, Richard]
Kindle App Ad

Oracle Database 10g Performance Tuning Tips & Techniques (Oracle Press) Kindle Edition

3.5 out of 5 stars 4 customer reviews

See all formats and editions Hide other formats and editions
Amazon Price
New from Used from
Kindle Edition
"Please retry"
£37.52

Length: 967 pages Enhanced Typesetting: Enabled Page Flip: Enabled
  • Due to its large file size, this book may take longer to download

Kindle Daily Deal
Kindle Daily Deals: Up to 70% off
Each day we unveil a new book deal at a specially discounted price - for that day only. Learn more about the Kindle Daily Deals or sign up for the Kindle Daily Deals Newsletter to receive free e-mail notifications about each day's deal.

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.

Product details

  • Format: Kindle Edition
  • File Size: 34239 KB
  • Print Length: 967 pages
  • Simultaneous Device Usage: Up to 4 simultaneous devices, per publisher limits
  • Publisher: McGraw-Hill Education; 1 edition (16 July 2007)
  • Sold by: Amazon Media EU S.à r.l.
  • Language: English
  • ASIN: B0013D4H8E
  • Text-to-Speech: Enabled
  • X-Ray:
  • Word Wise: Not Enabled
  • Enhanced Typesetting: Enabled
  • Average Customer Review: 3.5 out of 5 stars 4 customer reviews
  • Amazon Bestsellers Rank: #1,894,196 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
  •  Would you like to give feedback on images or tell us about a lower price?

Customer Reviews

3.5 out of 5 stars
Share your thoughts with other customers

Top Customer Reviews

Format: Paperback
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 32 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
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? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
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? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
Great book, very good value for money
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
click to open popover