High-Performance Oracle: Proven Methods for Achieving Optimum Performance and Availability

721 Pages·2002·4.27 MB·English

by  Geoff Ingram

Y

L
F

M

A

E

T

Team-Fly®
High-Performance Oracle®
Proven Methods for Achieving
Optimum Performance and Availability
Geoff Ingram
Wiley Publishing, Inc.

High-Performance Oracle®
Proven Methods for Achieving
Optimum Performance and Availability

High-Performance Oracle®
Proven Methods for Achieving
Optimum Performance and Availability
Geoff Ingram
Wiley Publishing, Inc.
Publisher: Robert Ipsen
Executive Editor: Robert M. Elliott
Assistant Editor: Emilie Herman
Managing Editor: John Atkins
New Media Editor: Brian Snapp
Text Design & Composition: MacAllister Publishing Services, LLC
Designations used by companies to distinguish their products are often claimed as trade-
marks. In all instances where John Wiley & Sons, Inc., is aware of a claim, the product names
appear in initial capital or ALLCAPITALLETTERS. Readers, however, should contact the appro-
priate companies for more complete information regarding trademarks and registration.
This book is printed on acid-free paper.
Copyright © 2002 by Geoff Ingram. All rights reserved.
Published by Wiley Publishing, Inc., Indianapolis, Indiana
Published simultaneously in Canada
No part of this publication may be reproduced, stored in a retrieval system, or transmitted
in any form or by any means, electronic, mechanical, photocopying, recording, scanning, or
otherwise, except as permitted under Section 107 or 108 of the 1976 United States Copyright
Act, without either the prior written permission of the Publisher, or authorization through
payment of the appropriate per-copy fee to the Copyright Clearance Center, Inc., 222 Rose-
wood Drive, Danvers, MA01923, [phone], fax [phone]. Requests to the Pub-
lisher for permission should be addressed to the Legal Department, Wiley Publishing, Inc.,
10475 Crosspointe Blvd., Indianapolis, IN 46256, [phone], fax [phone], Email:
[email protected].
Limit of Liability/Disclaimer of Warranty: While the publisher and author have used their
best efforts in preparing this book, they make no representations or warranties with respect
to the accuracy or completeness of the contents of this book and specifically disclaim any
implied warranties of merchantability or fitness for a particular purpose. No warranty may
be created or extended by sales representatives or written sales materials. The advice and
strategies contained herein may not be suitable for your situation. You should consult with
a professional where appropriate. Neither the publisher nor author shall be liable for any
loss of profit or any other commercial damages, including but not limited to special, inci-
dental, consequential, or other damages.
For general information on our other products and services please contact our Customer
Care Department within the United States at [phone], outside the United States at
[phone] or fax [phone].
Wiley also publishes its books in a variety of electronic formats. Some content that appears
in print may not be available in electronic books.
Library of Congress Cataloging-in-Publication Data:
Ingram, Geoff, 1962-
High performance Oracle : proven methods for achieving optimum
performance and availability / Geoff Ingram.
p. cm.
“Wiley Computer Publishing.”
Includes index.
ISBN 0-471-22436-7
1. Oracle (Computer file) 2. Relational databases. 3. Software
maintenance. I. Title.
QA76.9.D3 I53422 2002
005.75'85--dc21
Printed in the United States of America.
10 9 8 7 6 5 4 3 2 1
This book is dedicated to my wife Renata; to my children Rosalind,
Alexandra, Alice, and Sebastian; to my father Vincent;
and to the memory of my mother Muriel.

Acknowledgments
Special thanks go to Mark Clark, whose vision ultimately made the book possible, and
to Steve Shaw.
Special thanks also go to Bob Elliott and Emilie Herman at Wiley Publishing, Inc.
Bob turned the book proposal into something of a book in its own right. Hopefully the
end result justifies that. Emilie, in her own words, “edits with a heavy red pen,” which
is not actually as painful as it sounds and has definitely led to more concise content,
better organization, and improved readability. Thanks also to John Atkins for the final
polish, and Brian Snapp.
Honorable mentions go to colleagues and others, past and present, whose input
influenced the content in large and small ways. In no particular order: Wai Lee, Glen
Howell, Sheck Cho, Chris Chandler, Nisit Kotecha, Anoop Marld, Richard Dutton,
Arthur Muir, Susan Gruebel, Jose Garcia, Matt Solomon, Pradeep Malhotra, Michael
Wang, Ping Huang, Anna Lam, Peter Chellone, Mike Bean, Tony Way, Andy Knight,
Richard Kirkwood, Jenny Scott, Iain Beckingham, Carlos Tubau-Gamble, Simon Gre-
gory, Adrian Cockcroft, and Ray Leah.
Finally, thanks go to all those Oracle technologists, such as Thomas Kyte and
Jonathan Lewis, who contribute to bulletin boards and news groups on the Web, both
at Oracle and elsewhere. Without such people prepared to share their expertise free of
charge, the Oracle world would be a much poorer place.