tailieunhanh - Oracle Performance Tuning and Optimization

Oracle Corporation is one of the world’s largest vendors of software for managing information. Oracle has over 12,000 employees with offices in 93 countries around the world. One of the reasons Oracle software is so popular is the diversity of platforms it supports. In fact, Oracle software runs on almost every popular computer in the world and is used everywhere from home applications to giant corpora- tions. Because Oracle is expanding into video, audio, and textual data for consumer applications, the company is poised to become the leading software provider for the Information Superhighway | ¨ OracleOracle PerformancePerformance TuningTuning andand OptimizationOptimization Edward Whalen 201 West 103rd Street Indianapolis, Indiana 46290 i ToOracle my father. Performance Tuning & Optimization Acquisitions Editor Rosemarie Graham Copyright Ó 1996 by Sams Publishing Development Editors FIRST EDITION Byron Pearce All rights reserved. No part of this book shall be reproduced, stored in a retrieval Todd Bumbalough system, or transmitted by any means, electronic, mechanical, photocopying, Software Development recording, or otherwise, without written permission from the publisher. No patent Specialist liability is assumed with respect to the use of the information contained herein. Steve Flatt Although every precaution has been taken in the preparation of this book, the publisher and author assume no responsibility for errors or omissions. Neither is any Production Editor liability assumed for damages resulting from the use of the information contained Alice Martina Smith herein. For information, address Sams Publishing, 201 W. 103rd St., Indianapolis, IN 46290. Technical Reviewers David Kennedy International Standard Book Number: 0-672-30866-X Stephen Tallon Library of Congress Catalog Card Number: 95-72345 Editorial Coordinator 99 98 97 96 4 3 2 1 Bill Whitmer Interpretation of the printing code: the rightmost double-digit number is the year of the book’s printing; the rightmost single-digit, the number of the book’s printing. Technical Edit Coordinator For example, a printing code of 96-1 shows that the first printing of the book Lynette Quinn occurred in 1996. Formatter Composed in AGaramond and MCPdigital by Macmillan Computer Publishing Frank Sinclair Printed in the United States of America Editorial Assistants All terms mentioned in this book that are known to be trademarks or service marks Sharon Cox have been appropriately capitalized. Sams Publishing cannot attest to the accuracy of Andi Richter this information. Use of a term in this book should not