Oracle8i and Unix Performance Tuning

Features

• Cover Type: Paperback with 448 pages
• Published by: Prentice Hall PTR
• Edition: 1st Edition September 15, 2000
• Written in: English
• ISBN 10 Number: 0130187062
• ISBN 13 Number: 978-0130187062
• Book Dimensions: 9.3 x 7 x 1.1 inches
• Weighs: 1.8 pounds

From the Inside Flap
Preface

The purpose of this book is to share my experiences in the areas of UNIX and Oracle performance and tuning. The chapters of this book provide a awesome level of detail on the internal workings of the Oracle and UNIX kernels. The purpose of including so much detail is to give the reader a complete understanding of Oracle and UNIX. It is this understanding that will enable the reader to apply these concepts to specific applications and/or user environments, thus enabling the reader to maximize the performance of his or her environment.

It is a key characteristic of this book that only the latest versions of Oracle and UNIX are discussed, such as Oracle8i and Solaris 8. This will enable the reader to focus on the functionality and enhancements of the new versions, avoiding discussion of old releases.

Another characteristic of this book is that I have organized it into two major areas: data warehousing and Online Transaction Processing (OLTP). This edition of the book places more of an emphasis on application tuning since the application has the most control over the overall performance and scalability. It is important that the application be well designed and highly optimized.

Recommended prerequisites for this book are a basic understanding of SQL, UNIX shell language, and experience with UNIX system and Oracle database administration.

I have been a user of Oracle and UNIX across many different platforms including Sun, Sequent, HP, VAX/VMS, MS-DOS, Windows, and IBM RT. I hope you enjoy this book and find it useful in mastering the areas of performance and tuning. Good luck, and away we go!Complementary Materials

An ftp directory has been created to accompany this book at ftp://ftp.prenhall/pub/ptr/database.w-050/alomari. The directory contains white papers, utilities, and scripts available for download. The material in the ftp directory offers additional information associated with Oracle8 such as architecure white papers, product features, and performance tuning tips. There are also SQL scripts that can be used to monitor database performance. Best Regards,
Ahmed Alomari
Ahmed.Alomari@oracle

Back Cover Copy
Achieve breakthrough Oracle 8/8i performance!

• Optimize Web-centered enterprise applications
• Maximize OLTP and OLAP/DSS performance and scalability
• Tune UNIX, eliminate SQL bottlenecks, and master Oracle 8/8i's latest performance enhancements

Maximize performance: Tune Oracle8i and UNIX together!

Now, the #1 guide to Oracle tuning on UNIX platforms has been thoroughly updated for Oracle 8i! Oracle Senior Performance Engineer Ahmed Alomari covers every relevant optimization technique for every leading application and approach, including Web-centered development, OLTP, OLAP/DSS, and object-relational database systems.

Alomari covers the entire system lifecycle, showing how to achieve breakthrough performance by tuning both Oracle 8i and your underlying UNIX platform. Coverage includes:

• Choosing Oracle 8/8i and UNIX installation options that maximize performance
• Optimizing the UNIX kernel, memory, processors and I/O for your application
• Partitioning, star queries, and parallel DML
• Connection Manager, connection pooling, and multiple buffer pools
• Parallel query enhancements, I/O slaves, and multiple DBWR processes
• Oracle 8/8i optimizer and PRO*C enhancements
• Expert techniques for eliminating SQL bottlenecks
• State-of-the-art database performance benchmarking
• Specific solutions for Solaris, HP-UX, and Sequent

No matter how long you've been running Oracle and UNIX, you'll run them faster-and smarter-with Oracle8i & UNIX Performance Tuning!

Reader Reviews
This book is an excellent overview of how the Oracle RDBMS runs on the various flavors of the Unix operating system. Knowledgeable Oracle DBA's will take away many performance tuning tips with a complete understanding of why, when, and how to implement. The first two chapters on The Unix Kernel and Paging/Swapping should be required reading for anyone administering Oracle on Unix. Comment | | (Report this)