Oracle and UNIX Performance Tuning with CDROM [Paperback]

Ahmed Alomari (Author)

Book Description

Publication Date: May 1997

84916-6 The only way to truly optimize your database: Tune the Oracle DBMS and the UNIX kernel together. If you're running an Oracle production database system on a UNIX platform, there's only one way to truly maximize your performance: tune both Oracle and UNIX-and understand how the two interrelate. Oracle and UNIX Performance Tuning is the first book to address tuning of both current Oracle releases and the underlying Solaris, HP-UX, or Sequent Dynix systems they're running on. It's also the first Oracle database tuning book with detailed, specific coverage of optimizing both OLTP and decision support systems. Oracle Senior Engineer Ahmed Alomari begins by presenting a systematic approach to tuning Oracle databases based on UNIX, and showing how benchmarking and optimization fit into the development lifecycle. Next, he reviews important UNIX kernel-related issues that impact performance, and introduces effective techniques for tuning memory, processors, and I/O. The book also contains detailed coverage of optimizing SQL code-a factor often neglected in database tuning books, but which can powerfully impact database performance.Alomari makes in-depth recommendations for tuning both decision support and transaction applications - each of which impact the Oracle kernel in significantly different ways. No other tuning book covers specific DSS and OLTP issues in comparable detail. Oracle and UNIX Performance Tuning includes a CD-ROM with shell scripts for Solaris, HP-UX, and Sequent platforms, a performance monitor, Oracle scripts, a parameter reference, and extensive Oracle white papers on tuning and performance issues. Tuning Oracle without tuning UNIX is like tuning half the cylinders on your car. If you want all the performance you're paying for, you need to do both-and Ahmed Alomari's Oracle and UNIX Performance Tuning will show you how.

Editorial Reviews

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. Although this book may be used as a reference guide for UNIX kernel or Oracle startup parameters, it is intended to be an overall reference for concepts. The chapters of this book provide a tremendous level of detail on the internal workings of the Oracle and UNIX kernel. 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. The book covers Oracle 7.2 and 7.3, Sun Solaris 2.4 and 2.5, Sequent Dynix 4.1 and 4.2, and HP-UX 10. 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: Decision Support and Transaction Workloads. I felt that rather than focus on areas in the Oracle kernel and discuss each parameter, I would focus instead on the workload and discuss the affected areas of the Oracle kernel per workload.

Recommended prerequisites for this book are a basic understanding of SQL, UNIX shell language, and experience with UNIX system and Oracle7 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. In this book, I intend to cover in great detail the Sun Solaris, Sequent Dynix, and HP-UX operating systems.

I hope you enjoy this book and find it useful in mastering the areas of performance and tuning. To show my appreciation for UNIX, I had to start with a Chapter 0. Good luck, and away we go!

ACKNOWLEDGMENTS
This book is dedicated to my parents, Mukarram Alomari and Dr. Suha Alomari, and to Lana Gardi. My parents have always emphasized education and the pursuit of excellence. Lana Gardi is also a very special person in my life. Lana, soon to be my wife (hopefully by the time this book is published), has been wonderfully supportive of my career and the drafting of this book. Special thanks to my mother, Dr. Suha Alomari, who gives true meaning to the words commitment, dedication, and excellence. Her values and encouragement keep me constantly striving to excel.
Thanks to the rest of my family Mustafa, Mohammed, Munna, May, Abduallah, and Zena for their support and encouragement.

I would also like to sincerely thank Henry Dai of Oracle. It is a great pleasure to work woth such a talented technical inovator as well as a great manager and visionary.
I would also like to thank the Oracle engineers and support staff with whom I have had the pleasure of working on various issues. Thanks also to the Sun, HP, and Sequent engineers and support staff.
I would also like to thank the reviewers, Michael Machowicz, Omar Tahboub, and Salim Ahmed. Their diligent and careful review helped me improve the format and organization of the book.
Thanks also to Mark Taub of Prentice Hall and the Prentice Hall staff for the editing and publishing efforts of this book.
Best Regards, Ahmed Alomari EMAIL: [e-mail]

About the Author

AHMED ALOMARI is a Senior Performance Engineer with Oracle Corporation residing in Redwood Shores, California. Mr. Alomari has a tremendous amount of hands-on experience in administrating and tuning large scale UNIX and database systems. He has written many white papers on performance and tuning, and has spoken at several conferences. This book combines Mr. Alomari's personal experiences administrating and tuning large scale systems with his detailed knowledge of both UNIX and Oracle.

Product Details

• Paperback: 255 pages
• Publisher: Prentice Hall (May 1997)
• Language: English
• ISBN-10: 0138491674
• ISBN-13: 978-0138491673
• Product Dimensions: 9.2 x 7 x 0.7 inches
• Shipping Weight: 1.3 pounds (View shipping rates and policies)
• Average Customer Review: 4.2 out of 5 stars  See all reviews (4 customer reviews)
• Amazon Best Sellers Rank: #457,525 in Books (See Top 100 in Books)
  • #41 in Books > Computers & Technology > Databases > Oracle

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

3 of 3 people found the following review helpful:

3.0 out of 5 stars Ideally for System Administrators, January 26, 1999

By A Customer

This review is from: Oracle and UNIX Performance Tuning with CDROM (Paperback)

This is a good book for UNIX system administrators who support Oracle systems. However, unless you are an Oracle DBA who is really interested in UNIX internals, this book is not for you.

1 of 1 people found the following review helpful:

5.0 out of 5 stars Best Oracle tuning book I have read so far..., February 2, 1999

By A Customer

This review is from: Oracle and UNIX Performance Tuning with CDROM (Paperback)

If you are a DBA this book belongs on your shelf. It is packed with platform specific information as well as sage advice from a seasoned veteran of performance tuning.

1 of 1 people found the following review helpful:

5.0 out of 5 stars Very Good, August 7, 1998

By A Customer

This review is from: Oracle and UNIX Performance Tuning with CDROM (Paperback)

Excellent for those well versed in Unix. The index could have been better though. Definitely for those with some prior experience as Unix admin and DBA.