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.
Reviews
"This book is concise, practical and thorough! It starts with a high-level view of new 9i features and then drills down to the meat and potatoes of not just 9i tuning, but tuning skills that can be applied to any Oracle database. It speaks to the beginner developer and DBA, as well as the seasoned veteran tuner with equal added value for each. I really enjoyed the focus of the Disk I/O and Fragmentation chapter. It drills in the fact that no matter how high-tech or low-tech your disk technology is, you must adhere to the common sense basics and take ownership of your database datafiles, I/O, partitioning and fragmentation down to the disk level and not leave it in the hands of your hardware administrator. I also like the way he incorporates GUI (OEM) and line command options for those who are old school DBAs. He hits the new init.ora parameters, TKPROF and stored outlines. As always, he covers documented and undocumented init.ora parameters and an appendix of the GV$, V$ and X$ tables. The only thing I would have wished to be added was the hard-to-find proper use of the 'alter session set events' functionality to trace the optimizer decision process without the use of TKPROF. If you only have room for one Oracle tuning book on your shelf, make it this one. It's still the 'Gold Bible for Oracle Tuning.'"
-- Amazon Reader Review
About the Author
Richard J. Niemiec is chief executive officer of TUSC, as well as former president of the International Oracle Users Group-Americas and current president of the Midwest Oracle Users Group. Oracle Corp recognized him in 2001 as an Oracle Certified Master, making him one of the top six Oracle experts in the world at the time. He has worked with Oracle technology for more than a decade and, together with TUSC co-founders Bradley D. Brown and Joseph C. Trezzo, has donated literally hundreds of white papers and presentations to the Oracle technology community.
Click here to learn more about Rich.
Table of Contents |
|
Author
Richard J. Niemiec
Book Information
Paperback
823 pages
ISBN: 0072224738
Order it from Amazon
|
