In this book, you'll find hundreds of real-world examples and insider secrets compiled from TUSC's standing-room-only conference presentations and Oracle users 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 life cycle. 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; tune disk queries to maximize disk I/O and minimize fragmentation; 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; and refine your tuning skills by exploring the new features in Oracle8. Reviews "Finally, a book that doesn't put you to sleep and doesn't linger on trivia. The tips and insights are really excellent and teach a trick or two to even the most experienced user. Should figure in the list of top 10 books for Oracle experts." -- BookPool.com Reader Review "Wouldn't have expected anything less from Rich Niemiec. Truly brilliant! This book is a gold mine of information not just for DBAs, but for any developer who uses Oracle and wants to improve the quality of their work." -- Amazon Reader Review "This is a tremendous book. I was impressed after just the first chapter. Chapter one is packed full of information and tips and you see very quickly that the people from TUSC know what they're talking about. And best of all, they are willing to share all that knowledge with the rest of us. This book provides a level of detail that I have seldom found in other reference books. I can't wait for the next one in this series." -- 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 894 pages ISBN: 0078824346 Downloads Sample Scripts (PC) (64Kb) Sample Scripts (UNIX) (57Kb) Order it from Amazon
Chapter 1: Over a Decade of Tuning Experience Chapter 2: Basic Index Principles (Beginner Developer and Beginner DBA) Chapter 3: Disk I/O and Fragmentation (DBA) Chapter 4: Tuning the init.ora (DBA-Related) Chapter 5: Enterprise Manager and Tuning Pack (DBA and Developer) Chapter 6: Using EXPLAIN PLAN, TRACE and TKPROF (Developer and DBA) Chapter 7: Basic Hint Syntax (Developer and DBA) Chapter 8: Query Tuning (Developer and DBA) Chapter 9: Table Joins and Other Advanced Tuning Chapter 10: Using PL/SQL to Enhance Performance (Developer and DBA) Chapter 11: Using Parallel Features to Improve Performance Chapter 12: Oracle8 New Features (Developer and DBA) Chapter 13: Oracle8 and 8i New Tips (Developer and DBA) Chapter 14: The V$ Views (Developer and DBA) Chapter 15: The X$ Tables (DBA) Chapter 16: Using and Interpreting UTLESTAT/UTLBSTAT (Advanced DBA) Chapter 17: Performing a Quick System Review (DBA) Chapter 18: Monitor the System Using UNIX Utilities (DBA) Appendix A: Key init.ora Parameters (DBA) Appendix B: The V$ Views (DBA and Developer) Appendix C: The X$ Tables (DBA)