Oracle9i Performance Tuning Tips & Techniques [Paperback]

Richard J. Niemiec (Author)

Book Description

Publication Date: May 12, 2003 | ISBN-10: 0072224738 | ISBN-13: 978-0072224733 | Edition: 1

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!

Editorial Reviews

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

About the Author

McGraw-Hill authors represent the leading experts in their fields and are dedicated to improving the lives, careers, and interests of readers worldwide

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
• Average Customer Review: 4.3 out of 5 stars  See all reviews (12 customer reviews)
• Amazon Best Sellers Rank: #1,502,412 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

4 of 4 people found the following review helpful:

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

By 

Jaewoo Kim "OB-Wan" (Santa Monica, CA) - See all my reviews
(TOP 1000 REVIEWER)    (VINE VOICE)    (REAL NAME)   

Amazon Verified Purchase

This review is from: Oracle9i Performance Tuning Tips & Techniques (Paperback)

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

This review is from: Oracle9i Performance Tuning Tips & Techniques (Paperback)

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)   

This review is from: Oracle9i Performance Tuning Tips & Techniques (Paperback)

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!