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.
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.