Authors: Allan N. Packer
Pages: 538
Publisher: Prentice Hall PTR
ISBN13: 9780130834171
Maximize the performance of any enterprise database running on the Solaris Operating Environment!
Using this book, database professionals can optimize the performance and cost-effectiveness of virtually any database application running on the Solaris platform. Database specialist Allan Packer presents start-to-finish guidance for optimizing all four leading Solaris platform databases: Oracle (including Oracle9i), DB2, Sybase, and Informix XPS. Drawing on years of expertise as an engineer at Sun, Packer brings together best-practice guidelines for every aspect of Sun database server tuning.
Optimizing data layout, CPU and memory configuration, and system sizing
Identifying and resolving bottlenecks: a systematic, drill-down monitoring approach
Understanding database optimizers, database buffer cache, and other key subsystems
Demystifying the industry's leading benchmarks-and recognizing their limitations
Understanding the impact of Java technology on database application design
Contains a quick primer on database architecture and concepts