The Art and Science of Oracle Performance Tuning - Softcover

Lawson, Christopher

Softcover

ISBN 10: 1904347010 ISBN 13: 9781904347019

Publisher: Curlingstone, 2003

Synopsis

The Art and Science of Oracle Performance Tuning:

Complete and approachable guide to tuning best practice

For novice to intermediate Oracle DBAs and developers

Solving or planning for performance issues is a core part of the database professional's toolkit. The Oracle database is very flexible, making it suitable for a wide range of applications. Consequently, it is highly tunable, presenting a bewildering set of choices to the inexperienced. Tuning Oracle is as much about approach as about understanding the technology. It is more than tweaking parameters, or following a set prescription – it involves matching application-specific knowledge with what's happening inside the database.

Based on the author's long experience working with Oracle, the book uses a five-step model to help identify and isolate the cause of non-performance. This book shows you how to approach problems, get the information you need from Oracle, and follow the process through to success.

The Art and Science of Oracle Performance Tuning shows you:

A proven process for performance tuning

How to objectively categorize the problem

The human and business aspects of tuning as well as the technical know-how

How to trace problems to their root cause

Analyzing the cost of SQL statements

Gathering statistics – achieving quantifiable results

Devising and testing a solution

Case studies throughout illustrate key points

Curlingstone is a new imprint providing practical information on all aspects of the technology, techniques, and job roles that form the database community.

About this title

Synopsis

Solving or planning for performance issues is a core part of the database professional's toolkit. The Oracle database is very flexible, making it suitable for a wide range of applications. Consequently, it is highly tunable, presenting a bewildering set of choices to the inexperienced. Tuning Oracle is as much about approach as about understanding the technology. It is more than tweaking parameters, or following a set prescription - it involves matching application-specific knowledge with what's happening inside the database. Based on the author's long experience working with Oracle, the book uses a five-step model to help identify and isolate the cause of non-performance. This book shows the reader how to approach problems, get the information needed from Oracle, and follow the process through to success.

About the Author

Christopher Lawson is an independent consultant who specializes in performance tuning of data warehouse and financial applications. His articles on database management and performance tuning have appeared in numerous technical journals, and he is a frequent speaker at Oracle conferences. When he isn't tracking down elusive performance problems, Chris teaches courses on enterprise database systems for the University of Phoenix. He is also editor of the online magazine The Oracle Magician, available at www.OracleMagician.com. Chris earned his bachelor's degree and master's in business administration at the University of California, Irvine.

Edition details

• Publisher: Curlingstone
• Publication date: 2003
• ISBN 10: 1904347010
• ISBN 13: 9781904347019
• Binding: Paperback
• Language: English
• Edition number: 1
• Number of pages: 400