Oracle9i Performance Tuning Tips & Techniques (Paperback)

by Richard J. Niemiec (Author) "First, I want to note that this book is primarily focused on helping beginner and intermediate Oracle professionals understand and better tune Oracle systems..." (more)
Key Phrases: select userenv, full tablescans, query server processes, Enterprise Manager, Oracle Expert, Performance Manager (more...)

Editorial Reviews

Product Description
From the exclusive publishers of Oracle Press books comes a unique volume, packed with undocumented tips & techniques, for tuning and tailoring Oracle9i to perform at its peak. Author Rich Niemiec has been named by Oracle Corporation as one of the top six Oracle experts in the world!

From the Back Cover

Get Undocumented, Insider Advice

Maintain a high-performance Oracle9i environment using the proven tuning methods presented in this authoritative resource. Written by the experts at TUSC and developed through years of successful Oracle consulting experience, this book offers hundreds of essential tips guaranteed to enhance system performance. Real-world examples illustrate insider best practices and in-depth details throughout the book highlight the new tuning options available in Oracle9i.

• Select the best indexing options for a variety of situations
• Distribute key data files across available hardware disks
• Tune crucial init.ora parameters for peak database performance
• Take full advantage of Oracle Enterprise Manager
• Use EXPLAIN, TRACE, TKPROF, STORED OUTLINES, and other tools
• Specify hints to override the optimizer as necessary
• Automate queries using PL/SQL stored procedures
• Use the Parallel Executions Option (PEO) for enhanced performance
• Monitor and tune the database with STATSPACK
• Query the V$ views and X$ tables

See all Editorial Reviews

Product Details

• Paperback: 864 pages
• Publisher: McGraw-Hill Osborne Media; 1 edition (May 12, 2003)
• Language: English
• ISBN-10: 0072224738
• ISBN-13: 978-0072224733
• Product Dimensions: 9.1 x 7.2 x 1.7 inches
• Shipping Weight: 3.1 pounds (View shipping rates and policies)
• Average Customer Review: 4.3 out of 5 stars See all reviews (12 customer reviews)
• Amazon.com Sales Rank: #582,988 in Books (See Bestsellers in Books)

Customer Reviews

Most Helpful Customer Reviews

5 of 5 people found the following review helpful:

4.0 out of 5 stars Somewhat unrefined but worth reading, April 28, 2005

By	Jaewoo Kim (Santa Monica, CA) - See all my reviews (REAL NAME)

The author is obviously highly knowledgeable of Oracle. He is, after all, an Oracle Certified Master, which is the highest level of Oracle certification requiring two days of intensive lab testing. Most people fail to pass.

Overall the book is very well written and is full of useful knowledge. I found its chapters on indexes, Oracle Enterprise Manager, and X$ tables as among the best. I found its chapters on query tuning to be poor, failing to even mention transaction isolation levels and different locking.

This is not a book for beginners, but for experienced Oracle DBAs who wants to get a better handle on improving Oracle performance.

The downside of this book is that it is somewhat sloppily written and put together, almost as if the book was written as a midnight term paper. The information is valuable and of high quality, just that its level or organization and writing could have used 2 more months of refinement and rewriting.

6 of 8 people found the following review helpful:

3.0 out of 5 stars Somewhat interesting, but redundant, July 20, 2003

By A Customer

I have read previous book by Rich and found this one is not as good as the previous one.
As in previous book, there are too much of redundant information. For the experienced
database engineer this book is somewhat helpful, but do not expect an exciting reading.
Some of the chapters like init.ora parameters or v$ views are not really useful. In my opinion
about 400 pages would have been more than enough to cover performance tuning.
In the same time there are useful chapters that are interesting for even experienced DBA, such
us table joins and statspack. There are not enough information for 9i specific tuning tips on
automatic undo management and automatic PGA allocation

1 of 1 people found the following review helpful:

5.0 out of 5 stars Great read from novices to experts, July 10, 2006

By	Raymond Tay (singapore) - See all my reviews (REAL NAME)

The authors have really put in alot of effort in making sure that the Oracle database can be understood in every aspect, and this really makes tuning easier :) Surely, this is one of the best books around.

cheers!