Product Description
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.
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.
See all Product Description