Product Description

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.

---

Product Details

• Amazon Sales Rank: #552344 in Books
• Published on: 2001-05-29
• Original language: English
• Number of items: 1
• Binding: Paperback
• 404 pages

From the Publisher
For new Oracle DBAs, this is the only entry-level book on the market that teaches the essentials of keeping databases running at top performance.
Covers releases 7.3 through 8i for NT, Linux, and Unix platforms
Presents core components of tuning Oracle databases in order of tuning priorities - most important/relevant issues up front.
Topics are presented in a simple and easy-to-understand fashion.
Provides practical, results-oriented methodology that can be understood by those new to Oracle databases.
Provides practical, results-oriented methodology that can be understood by those new to Oracle databases.
NEW 'Myths & Folklore' feature: sidebar element that contains a myth debunked and the expected performance gain measured in time or throughput.

From the Back Cover

Learn to optimize and fine-tune your Oracle system's overall performance

Implement tuning solutions using the proven methodology found inside Oracle Performance Tuning 101 gives you step-by-step practical advice for removing bottlenecks, minimizing downtime, and increasing overall system performance. You'll also get tips for identifying Oracle's current bottlenecks, prioritizing and performing tuning operations, writing optimal SQL, interpreting statistics, and much more. Written in a clear and engaging style, this book explains how to manage the tuning efforts of various components of your entire system in a methodical fashion, eliminating all guesswork.

-Understand the key components of a tuning methodology
-Set performance objectives, establish goals, and cease efforts when goals are met
-Learn how to generate well-written SQL commands­­and know how to recognize poorly written SQL
-Tune and manage various components of the Oracle Instance
-Use meaningful Oracle initialization parameter settings
-Implement proactive management of space in the Oracle database
-Understand I/O tuning with extensive coverage on implementing RAID on Oracle
-Get details on operating system tuning for Solaris, HP-UX, AIX, and Windows NT

Every chapter includes one or more myths and folklores about the topic, examples, and an "In a Nutshell" section all geared to reinforce the knowledge you've acquired.

About the Author
Gaja Krishna Vaidyanatha (Coppell, TX) has over eight years of experience as an Oracle DBA at a variety of companies such as Quest Software, Brio Technology and Andersen Consulting LLP. He was also a Principal Instructor at Oracle for over three years developing portions of the Oracle8 DBA curriculum and delivering tuning consulting and training for many Fortune 500 companies. Gaja is a member of IOUG-A and was a VIP presenter at IOUG-A Live 2000.

John A. Kostelac, Jr. (Houston, TX) has been applying his expertise as an Oracle DBA for close to 10 years. John is Consulting Senior Principal Instructor for Oracle Corporation in Dallas.

---

Customer Reviews

Good effort to shed light on Performance myths and legends!
Very bold & responsible presentation of material.
I have been going through this book for some days
now and have already found it very useful.
The authors have come across with an entirely
new approach of performance tuning with emphasis
on "wait events". A holistic approach to tone the
database has been addressed. Best part about the
book is, it being like a soldiers story straight
from the battlefield!
I am quite happy with this buy.