Oracle Performance Tuning 101 (Oracle Press) - Softcover

Vaidyanatha, Gaja; Deshpande, Kirtikumar; Kostelac, John A.; Kostelac, John

Softcover

ISBN 10: 0072131454 ISBN 13: 9780072131451

Publisher: McGraw-Hill Education, 2001

Synopsis

Your Oracle career starts here! Ideal for those new to Oracle technology, this officially authorized guide teaches new DBAs the essentials of keeping an Oracle database running at top performance. You’ll get coverage of application, instance, database, I/O, OS, and contention tuning.

About this title

About the Authors

Gaja Krishna Vaidyanatha is currently the Director of Storage Management Products at Quest Software, Inc., providing technical and strategic direction for the storage management product line. He has more than ten years of technical expertise, with over nine years of industry experience working with Oracle systems. Prior to joining Quest, Gaja worked as a Technical Manager at Andersen Consulting, where he specialized in Oracle Systems Performance Management and lead the Oracle Performance Management SWAT Team within the Technology Product Services Group. In a prior life, Gaja was also a Consultant and Instructor at Oracle Corporation specializing in the core technologies of Oracle. His key areas of interests include performance architectures, scalable storage solutions, highly available systems, and system performance management for data warehouses and transactional systems. He holds a Masters Degree in Computer Science from Bowling Green State University, Ohio. He has presented many papers at various regional, national and international Oracle conferences and is currently in the faculty of the IOUG-A Master Class University. He is also a contributor to the Oracle-L listserver and can be reached at gajav64yahoo.com.

Kirtikumar Deshpande (Kirti Deshpande) has been working in the Information Technology field for over 20 years, including more than seven years as an Oracle DBA. Although a Biomedical Engineer by profession, he has chosen Information Technology as his career. He currently works with Verizon Information Services as a Senior Oracle Database Administrator and is a frequent contributor on the Oracle-L and LazyDBA listservers. He can be reached at kirti_deshpande64hotmail.com.

John A. Kostelac, Jr. is an Oracle database administration consultant and operates an information technology consulting firm. He specializes in performance and recovery issues for Oracle databases. Additionally, he is experienced in every phase of modeling, design and implementation of Oracle databases for a variety of applications. John can be reached by e-mail at john@winningstaff.com

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 Education
• Publication date: 2001
• Language: English
• ISBN 10: 0072131454
• ISBN 13: 9780072131451
• Binding: Paperback
• Number of pages: 436