Oracle and Unix Performance Tuning

Alomari, Ahmed

ISBN 10: 0138491674 / ISBN 13: 9780138491673

Editore: Prentice-Hall, 1997

Riguardo questo articolo

pp. 255. Codice articolo 183158858

Dati bibliografici

Titolo: Oracle and Unix Performance Tuning

Casa editrice: Prentice-Hall

Data di pubblicazione: 1997

Legatura: Brossura

Condizione: Used

Descrizione articolo

Riassunto:

A book/CD-ROM package on tuning both current Oracle releases and the underlying Solaris, HP-UX, or Sequent Dynix systems they run on, and on optimizing both OLTP and OLAP decision support systems. Presents a systematic approach to tuning Oracle databases based on UNIX, reviews UNIX kernal-related issues, and introduces techniques for tuning memory, processors, and I/O. Also covers optimizing SQL code. The companion CD-ROM contains tuning tools. Assumes basic understanding of SQL, UNIX shell language, and database administration. Annotation c. by Book News, Inc., Portland, Or.

Dalla quarta di copertina:

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.