Rick Greenwald - Achieving Extreme Performance with Oracle Exadata

ORACLEOracle Press

Rick Greenwald
Robert (Bob) Stackowiak
Maqsood Alam
Mans Bhuller

Copyright 2011 by The McGraw-Hill Companies, Inc. (Publisher). All rights reserved. Except as permitted under the United States Copyright Act of 1976, no part of this publication may be reproduced or distributed in any form or by any means, or stored in a database or retrieval system, without the prior written permission of the publisher.

ISBN: 978-0-07175260-2
MHID: 0-07-175260-9

The material in this eBook also appears in the print version of this title: ISBN: 978-0-07-175259-6, MHID: 0-07-175259-5.

All trademarks are trademarks of their respective owners. Rather than put a trademark symbol after every occurrence of a trademarked name, we use names in an editorial fashion only, and to the benefit of the trademark owner, with no intention of infringement of the trademark. Where such designations appear in this book, they have been printed with initial caps.

McGraw-Hill eBooks are available at special quantity discounts to use as premiums and sales promotions, or for use in corporate training programs. To contact a representative please e-mail us at bulksales@mcgraw-hill.com.

Information has been obtained by Publisher from sources believed to be reliable. However, because of the possibility of human or mechanical error by our sources, Publisher, or others, Publisher does not guarantee to the accuracy, adequacy, or completeness of any information included in this work and is not responsible for any errors or omissions or the results obtained from the use of such information.

Oracle Corporation does not make any representations or warranties as to the accuracy, adequacy, or completeness of any information contained in this Work, and is not responsible for any errors or omissions.

TERMS OF USE

This is a copyrighted work and The McGraw-Hill Companies, Inc. (McGraw-Hill) and its licensors reserve all rights in and to the work. Use of this work is subject to these terms. Except as permitted under the Copyright Act of 1976 and the right to store and retrieve one copy of the work, you may not decompile, disassemble, reverse engineer, reproduce, modify, create derivative works based upon, transmit, distribute, disseminate, sell, publish or sublicense the work or any part of it without McGraw-Hills prior consent. You may use the work for your own noncommercial and personal use; any other use of the work is strictly prohibited. Your right to use the work may be terminated if you fail to comply with these terms.

THE WORK IS PROVIDED AS IS. McGRAW-HILL AND ITS LICENSORS MAKE NO GUARANTEES OR WARRANTIES AS TO THE ACCURACY, ADEQUACY OR COMPLETENESS OF OR RESULTS TO BE OBTAINED FROM USING THE WORK, INCLUDING ANY INFORMATION THAT CAN BE ACCESSED THROUGH THE WORK VIA HYPERLINK OR OTHERWISE, AND EXPRESSLY DISCLAIM ANY WARRANTY, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO IMPLIED WARRANTIES OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. McGraw-Hill and its licensors do not warrant or guarantee that the functions contained in the work will meet your requirements or that its operation will be uninterrupted or error free. Neither McGraw-Hill nor its licensors shall be liable to you or anyone else for any inaccuracy, error or omission, regardless of cause, in the work or for any damages resulting therefrom. McGraw-Hill has no responsibility for the content of any information accessed through the work. Under no circumstances shall McGraw-Hill and/or its licensors be liable for any indirect, incidental, special, punitive, consequential or similar damages that result from the use of or inability to use the work, even if any of them has been advised of the possibility of such damages. This limitation of liability shall apply to any claim or cause whatsoever whether such claim or cause arises in contract, tort or otherwise.

For Elinor Greenwald, on her way to many successes; Josephine Greenwald, author of the forthcoming book Frog on a Log; and Robin Greenwald, who keeps things interesting along the way. For my wife, LuAnn Greenwald, who has made this wonderful family possible. And for my longtime best pal, Bailey Greenwaldwe miss you.

Rick Greenwald

For Jodie, my wife of over 30 years, who has always been there for me and has learned to say impressive technical phrases to my friends without having a full understanding of how to translate them.

Robert Stackowiak

To my parents, who are the reason for my being here; to my father-in-law, a professor and an author whose dedication and commitment inspired me to write; to my wonderful wife, Suraiya, who fully supported me in this ordeal and gave excellent input despite not knowing the Oracle jargon; and finally, to my wonderful children, Zuha and Firas, who are the inspiration of my life.

Maqsood Alam

For my parents, who taught me the value of education and hard work. For my brother, who stood by my shoulder guiding me through lifes tribulations (and without whom I would still be selling music and stacking frozen chickens!). For my dear wife, Ladi, and for our bundle of joy, Pavan.

Mans Bhuller

Rick Greenwald has been active in the computer industry for more than 25 years. He is currently Director of Partner Enablement at Oracle, where he has worked for more than 10 years. He is also the author or coauthor of more than 15 books, including the best-selling Oracle Essentials for OReilly & Associates, now in its fourth edition; Beginning Oracle Application Express from Wiley; Professional Oracle Programming from Wrox; and Oracle Data Warehousing and Business Intelligence Solutions from Wiley.

Robert (Bob) Stackowiak, vice-president of Business Intelligence and Data Warehousing in the Enterprise Solutions Group at Oracle, has worked for more than 20 years in the IT industry. His roles have included software development, management of software development, systems engineering, sales and sales consulting, and new business innovation and development. Bob has spoken at numerous computer-related conferences and has conducted briefings with companies around the world. He has coauthored several books, including Oracle Essentials: Oracle Database 11g (4th Edition) by OReilly and Oracle Data Warehousing and Business Intelligence Solutions by Wiley. In addition, his papers regarding data warehousing and computer and software technology have appeared in publications such as The Data Warehousing Institutes Journal of Data Warehousing.

Maqsood Alam, senior manager of product development at Oracle, is a software professional with more than 15 years of experience working with Oracle technologies, specializing in databases, maximum availability architectures, data warehousing, database migrations, and business intelligence. His current initiatives are focused on evangelizing Oracle Exadata, performing customer Proof-Of-Concepts and benchmarks, promoting best practices for migrations to Oracle from Oracle and non-Oracle databases, and also providing support to customers undergoing large Exadata implementations. He is an Oracle Certified Professional and holds a masters and a bachelors degree in computer science.

Mans Bhuller, senior director of Database, Operating Systems and Management, Enterprise Solutions Group, Oracle, has worked at the forefront of emerging technologies at Oracle Corporation for the last 14 years. In this role, he has been paving the way for the Oracle Exadata Database Machine and other foundational technologies, such as Real Application Clusters (RAC), Grid, and Private Cloud. Mans is active in the Oracle Enterprise Architect community and has visited hundreds of customers. Recently, he has been building internal teaching classes around Exadata and Private Cloud and training others.