Oracle Performance Tuning 101 - Softcover

Gaja Krishna Vaidyanatha; Kirtikumar Deshpande; John A. Kostelac

Softcover

ISBN 10: 0072131454 ISBN 13: 9780072131451

Publisher: McGraw-Hill/Osborne Media, 2001

Synopsis

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.

About this title

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.

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.

Edition details

• Publisher: McGraw-Hill/Osborne Media
• Publication date: 2001
• Language: English
• ISBN 10: 0072131454
• ISBN 13: 9780072131451
• Binding: Paperback
• Number of pages: 404