From the Author
Buy and Read this Book and you'll be Great at Tuning Oracle!
Whether you are a DBA or Developer, buy and read this whole book and you will learn what I have learned painfully in over a decade of tuning Oracle. This was VERY painful to write and I only wrote it so that YOU could feel that great feeling from making the impact that tuning brings. I repeat some topics in the book more than once so that each chapter can be read independently (hard to have the time to read it all at once). This is my gift back to you
make sure that you take advantage of it. Also, there is no CD ... I highly recommend the books PL/SQL Tips and Techniques by Joe Trezzo and Oracle8i Web Development by Bradley Brown. Also, an advanced tuning book on Latches is great by Steve Adams and on UNIX tuning by Ahmed Alomari.
From the Back Cover
Expert Technical Knowledge at the Turn of a Page.
Tune and tailor your Oracle7 or Oracle8 system to perform at its peak using this one-of-a-kind reference, designed for every Oracle database administrator, programmer, and user.
In Oracle Performance Tuning Tips & Techniques, you'll find hundreds of real-world examples and insider secrets compiled from TUSC's standing-room only conference presentations and Oracle User Groups worldwide. From finding and fixing bottlenecks to enhancing performance using PL/SQL, this authoritative guide reveals proven methods for getting the most from your Oracle system throughout its lifecycle.
- Discover the Top 10 Tuning Tips used by industry experts to improve performance
- Maximize tuning with the most important basic, advanced, and undocumented INIT.ORA parameters for Oracle7 and Oracle8
- Use Explain Plan and Tkprof to uncover problem queries that, when corrected, result in peak performance
- Explore the new features in Oracle8 to gain peak performance by uncovering problem queries
- Refine your tuning skills by exploring the new features in Oracle8
- Take advantage of key V$ Views and X$ Tables to enhance performance
Developed through years of consulting expertise, Oracle Performance Tuning Tips & Techniques is packed with time-saving tuning gems designed to ensure top system performance.