D73668GC11_sg2

Please download to get full document.

View again

of 260
All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
Information Report
Category:

Instruction manuals

Published:

Views: 12 | Pages: 260

Extension: PDF | Download: 2

Share
Related documents
Description
Oracle Exadata
Tags
Transcript
  Exadata Database Machine  Administration Workshop Student Guide - Volume II D73668GC11 Edition 1.1  April 2012 D76623  Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Disclaimer This document contains proprietary information and is protected by copyright and other intellectual property laws. You may copy and print this document solely for your own use in an Oracle training course. The document may not be modified or altered in any way. Except where your use constitutes fair use under copyright law, you may not use, share, download, upload, copy, print, display, perform, reproduce, publish, license, post, transmit, or distribute this document in whole or in part without the express authorization of Oracle. The information contained in this document is subject to change without notice. If you find any problems in the document, please report them in writing to: Oracle University, 500 Oracle Parkway, Redwood Shores, California 94065 USA. This document is not warranted to be error-free. Restricted Rights Notice If this documentation is delivered to the United States Government or anyone using the documentation on behalf of the United States Government, the following notice is applicable: U.S. GOVERNMENT RIGHTS The U.S. Government’s rights to use, modify, reproduce, release, perform, display, or disclose these training materials are restricted by the terms of the applicable Oracle license agreement and/or the applicable U.S. Government contract. Trademark Notice Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners. Author Peter Fusek Technical Contributors and Reviewers Akshay Shah Alex Tsukerman Amit Ganesh Andrew Babb Aslam Edah-Tally Barb Lundhild Bharat Baddepudi Bill Hodak Boris Erlikhman Branislav Valny Bruce Kyro Caroline Johnston Christian Craft Dan Norris Dave Winter David Hitchcock Douglas Utzig Ed Gilowski Eric Siglin Georg Schmidt Harald van Breederode James He Jean-Francois Verrier Jia Shi Jim Hall Jim Spiller Jim Viscusi Joel Goodman Juan Loaiza Kam Shergill Kevin Jernigan Kodi Umamageswaran Krishnanjani Chitta Larry Justice Lawrence To Louis Nagode Mahesh Subramaniam Maria Billings Mark Fuller Mark Scardina Mark Van de Wiel Marshall Presser Martin Jensen Michael Cebulla Michael Nowak  Nilesh Choudhury Ravindra Dani Raymond Dutcher Richard Exley Robert Carlin Robert Pastijn Roger Hansen Sabyasachi Banerjee Scott Gossett Sriram Palapudi Steven Lemme Sue Lee Sugam Pandey Sumeet Lahorani Sundararaman Sridharan Tim Shelter Umesh Panchaksharaiah Uwe Hesse Varun Malhotra Vern Wagman Vijay Sridharan Vikram Kapoor Vimala Jacob Graphic Designer Satish Bettegowda Editors Malavika Jinka Smita Kommini Aju Kumar Publisher  Michael Sebastian Almeida   iii Contents 1 Introduction Course Objectives 1-2  Audience and Prerequisites 1-3 Course Contents 1-4 Terminology 1-5  Additional Resources 1-6 Practice 1 Overview: Introducing the Laboratory Environment 1-7 2 Exadata Database Machine Overview Objectives 2-2 Introducing Database Machine 2-3 Why Database Machine? 2-4 Introducing Exadata Storage Server 2-6 Exadata Storage Server Architecture Overview 2-7 Exadata Storage Server Features Overview 2-8 Exadata Storage Server X2-2 Hardware Details (Sun Fire X4270 M2) 2-10 Exadata Storage Server X2-2 Specifications 2-11 Database Machine X2-2 Full Rack 2-12 X2-2 Database Server Hardware Details (Sun Fire X4170 M2) 2-13 Start Small and Grow 2-14 Database Machine X2-8 Full Rack 2-15 X2-8 Database Server Hardware Details (Sun Fire X4800 M2) 2-16 Database Machine Capacity 2-17 Database Machine Performance 2-18 Exadata Storage Expansion Racks 2-19 InfiniBand Network 2-20 Database Machine Support Overview 2-21 Database Machine Benefits for Data Warehousing 2-22 Database Machine Benefits for OLTP 2-24 Quiz 2-25 Summary 2-27   iv 3 Exadata Database Machine Architecture Objectives 3-2 Database Machine Architecture Overview 3-3 Database Machine Network Architecture 3-5 InfiniBand Network Architecture 3-7 X2-2 Full Rack Leaf Switch Topology 3-8 Spine and Leaf Topology 3-9 Scale Performance and Capacity 3-10 Typical Scaling Scenarios 3-11 Scaling Out to Eight Racks 3-13 Scaling Out Beyond Eight Racks 3-14 Interconnecting Quarter Racks 3-15 InfiniBand Network External Connectivity 3-17 Database Machine Software Architecture Overview 3-18 Database Machine Software Architecture Details 3-21 Disk Storage Entities and Relationships 3-22 Flash Storage Entities and Relationships 3-24 Disk Group Configuration 3-25 Quiz 3-26 Summary 3-30  Additional Resources 3-31 Practice 3 Overview: Introducing Exadata Cell Architecture 3-32 4 Key Capabilities of Exadata Database Machine Objectives 4-2 Classic Database I/O and SQL Processing Model 4-3 Exadata Smart Scan Model 4-4 Exadata Smart Storage Capabilities 4-5 Exadata Smart Scan Scale-Out Example 4-8 Exadata Hybrid Columnar Compression Overview 4-11 Exadata Hybrid Columnar Compression Data Organization 4-12 Exadata Smart Flash Cache Overview 4-13 Exadata Smart Flash Cache Intelligent Caching 4-14 Using Exadata Smart Flash Cache 4-15 Exadata Smart Flash Log Overview 4-17 Exadata Storage Index Overview 4-18 Storage Index with Partitions Example 4-20 Database File System 4-21 I/O Resource Management Overview 4-22 Benefits Multiply 4-23 Quiz 4-24
We Need Your Support
Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

Thanks to everyone for your continued support.

No, Thanks