Oracle8 and UNIX Performance Tuning - Softcover

Alomari, Ahmed

Softcover

ISBN 10: 013907676X ISBN 13: 9780139076763

Publisher: Prentice Hall, 1998

Synopsis

This is the book/cd-rom package that describes how to optimize the performance of an Oracle 8 database running on a UNIX system. Covered systems include Solaris, Sequent, and HP-UX. One of the things that will separate this book from the competition is that it provides specific tuning direction for both OLTP databases and DSS databases. No other tuning book breaks the direction down to this level of detail. In addition, a CD-ROM will be included that contains shell scripts, a performance monitor for Oracle. Oracle scripts, a parameter reference, and related white-papers.

About this title

From the Back Cover

90767-5

The #1 Guide to Oracle8 and Oracle7 Tuning on UNIX® Platforms

Tuning Oracle without tuning UNIX® is like tuning half the cylinders onyour car. If you want all the performance you're paying for, you need to do both-and Oracle8 and UNIX® Performance Tuning will show you how.

Oracle Senior Performance Engineer Ahmed Alomari covers virtually every relevant optimization technique in Oracle8, Oracle7, and three leading versions of UNIX®: Solaris 2.6, HP-UX 11, and Sequent Dynix/ptx 4.4. He presents in-depth coverage of both OLTP and DSS applications, covering optimization of the UNIX® kernel, memory, processors and I/O, and all these major Oracle8 performance enhancements:

• Partitioning
• Star queries
• Parallel DML
• Connection Manager
• Connection pooling
• Multiple buffer pools
• Parallel query enhancements
• I/O slaves
• Multiple DBWR processes
• Optimizer enhancements
• PRO*C enhancements
• Any correspondence should be sent AALOMARI@us.oracle.com

Learn new techniques for optimizing object-relational databases. Use the tips and techniques offered in this book to help eliminate SQL code bottlenecks. Whether you're running Oracle8 or Oracle7 on a UNIX® platform, this is the book you need to optimize your environment.

Oracle8 and UNIX® Performance Tuning includes a CD-ROM which consists of performance monitoring scripts, product information, and extensive white papers.

Synopsis

This is the first book that presents detailed coverage of maximizing Oracle8 performance by tuning both the database and the underlying UNIX system. It is also the only database tuning book that presents detailed coverage of tuning both OLTP and decision support databases. The book begins by introducing UNIX kernel-related issues that impact performance; then covers techniques for tuning memory, processors and I/O. There is detailed coverage of how to eliminate SQL bottlenecks, as well as specific guidance on tuning both OLTP and DSS systems. Installation and configuration issues are also discussed. Coverage reflects Oracle8 and the latest versions of Sun, HP-UX and Sequent UNIX.

Edition details

• Publisher: Prentice Hall
• Publication date: 1998
• ISBN 10: 013907676X
• ISBN 13: 9780139076763
• Binding: Paperback
• Language: English
• Number of pages: 352