Oracle 9i Performance Tuning

Author: Nimiaike
Publisher:
Publish Date: 2004-03-01
Features: The main purpose of this book is to help beginners and Oracle professionals understand and better optimize Oracle systems. It also includes many specialized topics, but its primary goal is to help frustrated professionals find simple tips that can help improve performance. The book has a simple objective: to provide a wealth of techniques that can be used in various situations to make the system faster. The book comprehensively and systematically introduces various methods and techniques for maintaining high performance in the Oracle9i environment. Written by Richard J. Niemiec, CEO of TUSC, with his extensive experience in Oracle consulting and debugging, the book has become an "authority" in performance optimization books. The book demonstrates the best practices for performance tuning to readers with detailed examples and provides an in-depth analysis of the new performance tuning options introduced in Oracle9i. Main Content: · Selecting the best index options for different scenarios; · Distributing important data files across available hard drives; · Optimizing database performance using key init.ora parameters; · Making full use of Oracle Enterprise Manager; · Using EXPLAIN, TRACE, TKPROF, STORED OUTLINES, and other tools; · Using hints as needed to rewrite optimizer settings; · Executing automatic queries using PL/SQL stored procedures; · Improving performance using Parallel Execution Option (PEO); · Monitoring and tuning the database using STATSPACK; · Querying V$ views and X$ tables.