Oracle and UNIX Performance Tuning: Maximizing Client/Server Performance (Bk/CD-ROM) - Softcover

Alomari, Ahmed

Softcover

ISBN 10: 0138491674 ISBN 13: 9780138491673

Publisher: Prentice Hall, 1997

Synopsis

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.

About this title

About the Author

AHMED ALOMARI is a Senior Performance Engineer with Oracle Corporation residing in Redwood Shores, California. Mr. Alomari has a tremendous amount of hands-on experience in administrating and tuning large scale UNIX and database systems. He has written many white papers on performance and tuning, and has spoken at several conferences. This book combines Mr. Alomari's personal experiences administrating and tuning large scale systems with his detailed knowledge of both UNIX and Oracle.

Edition details

• Publisher: Prentice Hall
• Publication date: 1997
• ISBN 10: 0138491674
• ISBN 13: 9780138491673
• Binding: Paperback
• Language: English
• Number of pages: 288