Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

Overview

  • Turbocharge your Oracle, DB2, Sybase, or Informix database environment!

  • Covers every aspect of database and Solaris Operating Environment tuning

  • Optimize data layout, CPU and memory configuration, and system sizing

  • Identify and resolve bottlenecks, step-by-step

  • Understand industry-leading benchmarks

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