Oracle Performance Tuning

Front Cover
O'Reilly & Associates, 1993 - Database management - 603 pages

The Oracle relational database management system is the most popular database system in use today. Organizations ranging from government agencies to small businesses, from large financial institutions to universities, use Oracle to make sense of their data. Running on computers as diverse as mainframes, minicomputers, workstations, PCs, and Macintoshes, Oracle provides virtually identical functions across machine boundaries.Oracle offers tremendous power and flexibility, but at some cost. Demands for fast response, particularly in online transaction processing systems, make performance a major issue. With more organizations downsizing and adopting client-server and distributed database approaches, performance tuning becomes all the more vital.This book pulls together the experiences of many Oracle system users and administrators who have learned how to tune their Oracle systems --running either RDBMS Version 6 or Version 7--to best advantage. It answers questions like:

  • "I've been waiting 30 minutes for a response to my query-- what's going on?"
  • "My system administrator says our system is I/O-bound-- what can I do?"
  • "Our application ran fine in testing, but the response is terrible now that we're in production--help!"
Too many organizations respond to performance problems by throwing money at the problems--either by buying larger and more expensive computers or by hiring expert consultants. But, whether you're a manager, a designer, a programmer, a database administrator, or a system administrator, there's a lot you can do on your own to dramatically increase the performance of your existing Oracle system. You may find that this book can save you the cost of a new machine; at the very least, it will save you a lot of headaches.

From inside the book

What people are saying - Write a review

We haven't found any reviews in the usual places.

Contents

Overview
1
What Causes Performance Problems?
19
Tuning for Managers and Planners
31
Copyright

35 other sections not shown

Common terms and phrases

About the author (1993)

Peter Corrigan runs a small consulting company in Australia called Gauntlet Computers and works as a senior database administrator and project leader developing Oracle applications and tuning systems. His speciality areas include client-server architecture and application downsizing, and he is the co-developer of the Rainbow Financial package, sold internationally. He is a frequent speaker on the topic of tuning and programming at the Oracle Asia Pacific user group conferences and the Victoria Oracle user's group.

As a database administrator on a financial IMS project about eight years ago, Mark Gurry was asked to investigate his company's database direction for the next five years. The number of users was up to 950, the cost of maintaining the mainframes was huge, and he'd heard about relational databases and downsizing. After much investigation, he chose Oracle, and has stuck with the system ever since. He has worked as Manager of Computing and Network Services, senior database administrator, senior Oracle technical support, and other jobs. He now has a small consulting company called New Age Consultants. Mark has worked for many large organizations and is currently working for Telecom Australia, the largest computer site in Australia and one of the largest in the world. He has also spoken on tuning at Oracle user group meetings and has given internal tuning courses at several of his larger client sites. He has been a senior team member on award-winning systems that have been developed using Oracle.

Bibliographic information