Oracle and Unix Performance Tuning

84916-6 The only way to truly optimize your database: Tune the Oracle DBMS and the UNIX kernel together. If you're running an Oracle production database system on a UNIX platform, there's only one way to truly maximize your performance: tune both Oracle and UNIX-and understand how the two interrelate. Oracle and UNIX Performance Tuning is the first book to address tuning of both current Oracle releases and the underlying Solaris, HP-UX, or Sequent Dynix systems they're running on. It's also the first Oracle database tuning book with detailed, specific coverage of optimizing both OLTP and decision support systems. Oracle Senior Engineer Ahmed Alomari begins by presenting a systematic approach to tuning Oracle databases based on UNIX, and showing how benchmarking and optimization fit into the development lifecycle. Next, he reviews important UNIX kernel-related issues that impact performance, and introduces effective techniques for tuning memory, processors, and I/O. The book also contains detailed coverage of optimizing SQL code-a factor often neglected in database tuning books, but which can powerfully impact database performance.Alomari makes in-depth recommendations for tuning both decision support and transaction applications - each of which impact the Oracle kernel in significantly different ways. No other tuning book covers specific DSS and OLTP issues in comparable detail. Oracle and UNIX Performance Tuning includes a CD-ROM with shell scripts for Solaris, HP-UX, and Sequent platforms, a performance monitor, Oracle scripts, a parameter reference, and extensive Oracle white papers on tuning and performance issues. Tuning Oracle without tuning UNIX is like tuning half the cylinders on your car. If you want all the performance you're paying for, you need to do both-and Ahmed Alomari's Oracle and UNIX Performance Tuning will show you how.