The book assumes an understanding of relational database concepts and a familiarity with Oracle. It is targeted primarily for database professionals such as DBAs, developers, and system analysts with two to three years of experience in the development, implementation, and maintenance of relational databases using some RDBMS, preferably Oracle. A junior DBA or a developer can use the scripts of the book under the guidance of a senior DBA or developer.

Klappentext

Presents an ideal mix of theory and practice, which allows the reader to understand the principle behind the application.; Coverage of performance tuning of datawarehouses offers readers the principles and tools they need to handle large reporting databases.; Material can also be used in a non-Oracle environment; Highly experienced author.

Inhalt

• Database application development * Performance tuning methodology * Tuning conceptual level of a database * Internal level of an Oracle database * Tuning of disk resident data structures * Tuning of memory resident data structures * Oracle utility for tuning and optimization * Optimization of the external level of a database * Query tuning and optimization under Oracle 8i * Special features of Oracle 8i and a glimpse into Oracle 9i * Tuning the data warehouse at all levels * Web-based database applications * Appendices