tailieunhanh - Oracle Performance Tuning for 10gR2, Second Edition

Tuning of SQL code is generally cheaper than changing the data model. Physical and configuration tuning involves a search for bottlenecks that often points to SQL code or data model issues. Building an appropriate data model and writing properly performing SQL code can give 100%+ performance improvement. Physical and configuration tuning often gives at most a 25% performance increase. | Oracle Performance Tuning and Optimization Edward Whalen SAMS PUBLISHING 201 West 103rd Street Indianapolis Indiana 46290 To my father. Copyright 1996 by Sams Publishing FIRST EDITION All rights reserved. No part of this book shall be reproduced stored in a retrieval system or transmitted by any means electronic mechanical photocopying recording or otherwise without written permission from the publisher. No patent liability is assumed with respect to the use of the information contained herein. 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 liability assumed for damages resulting from the use of the information contained herein. For information address Sams Publishing 201 W. 103rd St. Indianapolis IN 46290. International Standard Book Number 0-672-30866-X Library of Congress Catalog Card Number 95-72345 99 98 97 96 4 3 2 1 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. For example a printing code of 96-1 shows that the first printing of the book occurred in 1996. Composed in AGaramond andMCPdigital by Macmillan Computer Publishing Printed in the United States of America All terms mentioned in this book that are known to be trademarks or service marks have been appropriately capitalized. Sams Publishing cannot attest to the accuracy of this information. Use of a term in this book should not be regarded as affecting the validity of any trademark or service mark. Publisher and President Richard K. Swadley Acquisitions Manager Greg Wiegand Development Manager Dean Miller Managing Editor Cindy Morrow Marketing Manager Gregg Bushyeager Acquisitions Editor Rosemarie Graham Development Editors Byron Pearce Todd Bumbalough Software Development Specialist Steve Flatt Production Editor Alice Martina Smith Technical Reviewers David Kennedy .