Oracle8 and UNIX Performance Tuning

Oracle8 and UNIX Performance Tuning, 1/e

Ahmed Alomari, Oracle Corp., Silicon Valley, California

Published July, 1998 by Prentice Hall PTR (ECS Professional)

See other books about:
ORACLE

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.

Author Bio

AHMED ALOMARI is Senior Performance Engineer with Oracle Corporation. He has extensive hands-on experience in managing and tuning large-scale UNIX® and database systems. Alomari has written many white papers on Oracle and UNIX® performance tuning, and has spoken at several conferences. He resides in Redwood City, California.