Troubleshooting Oracle Performance

Front Cover
Apress, Aug 20, 2008 - Computers - 586 pages
The Oracle database engine has become a huge piece of software. This not only means that a single human can no longer be proficient in using all the features provided in recent versions, but it also means that some of them will rarely be used. Actually, in most situations, it is enough to know and take advantage of a limited number of core features in order to use the Oracle da- base engine efficiently and successfully. This is precisely why in this book I will cover only the features that, based on my experience, are necessary to troubleshoot most of the databa- related performance problems you will encounter. Structure of This Book This book is divided into five parts: Part 1 covers some basics that are required to read the rest of the book. Chapter 1, “Perf- mance Problems,” explains not only why it is essential to approach performance problems at the right moment and in a methodological way but also why understanding business needs and problems is essential. Chapter 2, “Key Concepts,” describes the operations carried out by the database engine when parsing and executing SQL statements. It also introduces some terms that are frequently used in the book. Part 2 explains how to approach performance problems in an environment that is based on the Oracle database engine. Chapter 3, “Identifying Performance Problems,” provides a detailed analysis road map for identifying performance problems. Several tools and te- niques that can be used with it are also described.
 

What people are saying - Write a review

User ratings

5 stars
4
4 stars
1
3 stars
1
2 stars
0
1 star
0

User Review - Flag as inappropriate

I never read an easy and quite excellent book. all credit goes to Christian...he is brilliant..Thanks a ton Christian for helping me to understand tuning.

User Review - Flag as inappropriate

Excellent book that I'd highly recommend for Oracle DBAs concerned with Oracle SQL optimization and performance. Straight forward and easy to understand with excellent detailed and practice examples and in depth research into options and functionality. Its the best general purpose book I know of for insuring good SQL optimization through object statistics, installation parameters and advanced features such as sql baselines.
I recommended it on my blog and used some of the examples in my recent conference presentation at the Northern California users group:
http://db-optimizer.blogspot.com/2009/11/oracle-books-online.html
 

Contents

9179ch02final
13
9179ch03final
34
9179ch04final
107
9179ch05final
169
9179ch06final
195
9179ch07final
247
9179ch08final
306
9179ch09final
339
9179ch10final
409
9179ch11final
459
9179ch12final
527
9179AppAfinal
549
9179AppBfinal
563
9179INDXfinal
567
Copyright

Other editions - View all

Common terms and phrases

About the author (2008)

Since 1995, Christian Antognini has been focusing on understanding how the Oracle database engine works. His main interests range from logical and physical database design, to the integration of databases with Java applications, the query optimizer, and basically everything else related to performance management and tuning. He is working as a senior consultant and trainer at Trivadis AG in Z rich, Switzerland. If he is not helping one of his customers to get the most out of Oracle, he is somewhere lecturing on optimization or new Oracle database features for developers. He is member of the Trivadis Performance Team and of the OakTable Network).

Bibliographic information