Oracle Performance Tuning 101

by Gaja Vaidyanatha, Kirtikumar Deshpande, John A. Kostelac

Tuning Oracle databases or Oracle Performance Management (OPM) is what database administrators (DBAs) do to help the database run optimally. With the increase in e-commerce and deployment of databases and applications on the Internet, the task of keeping databases running is becoming increasingly important. This entry-level study teaches the essentials of keeping databases running at top performance. The guide covers releases 7.3 through 8i for NT, Linux and Unix platforms.

Paperback

First published May 1, 2001

Reviews

[John · Rating 5 out of 5]

This book represents the start of a fundamental change in the approach to Oracle Performance Tuning. From an endless "faster, faster" statistically based method of rigid "IF...THEN...ELSE...END IF;" rules to a dynamic method based on constrained resources influenced by "Queuing Theory" (Method R, Cary Milsap) taking into consideration the entire system, e.g., END TO END, with the User's Experience as our guide, this book is the start to successful Performance Tuning. Ultimately, iris the User Experience that must be improved. And to do that we must have a complete process that covers all aspects of the system as a whole and yet has an obvious end point lest we simply iterate infinitely without adding real value. This tome is a great place to start whether running Oracle 7, Oracle 8, Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g, or the current Oracle 12cR2. Regardless of the Version, regardless of the Application, regardless of the Line of Business, or any limitations imposed the processes still work, even if there are now a few more things to look at and some you need not bother with. Read it. It's worth the effort.

Gaja and Kirti are both brilliant problem solvers and teachers. Ultimately, that is what a book is about; a problem that needs solving and someone who needs some help with it.