"Database Performance Tuning and Optimization" comprehensively address each level separately by focusing first on the underlying principles and the root cause, and then propose both theoretical and practical solutions using the Oracle 8i instance as an RDBMS. This book combines theory with practical tools (in the form of Oracle and UNIX shell scripts) to overcome the problem of tuning and optimizing the DBA and developer, regardless of whether they use Oracle. Topics and features: * An integrated approach to tuning by increasing the third level of the database (conceptual, internal and external) for optimal performance * The balance of theory with practice, develop the principles and then apply them to other RDBMSs, not just Oracle * Includes a CD-ROM that contains all the scripts and the methods used in the book * Coverage of the data warehouse to give readers much-needed principles and reporting tools for tuning large databases * Scope web-based database * Appendix B shows how to create an instance and related database and all objects * Provides useful exercises, references and examples of Oracle 8i and 9i select Based on nearly two decades of experience as an Oracle developer and DBA, the authors provide comprehensive coverage of basic principles and methodology of tuning and optimizing database performance.