没有合适的资源?快使用搜索试试~ 我知道了~
首页Exadata官方培训教材
Exadata官方培训教材
需积分: 31 21 下载量 89 浏览量
更新于2023-03-16
评论
收藏 3.21MB PDF 举报
D67016GC20_Exadata_workshop_Part1.pdf
资源详情
资源评论
资源推荐
Exadata and Database Machine
Administration Workshop
Student Guide
D67016GC20
Edition 2.0
January 2011
D71669
Copyright © 2010, Oracle and/or it 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.
Authors
Peter Fusek
Jean-Francois Verrier
Mark Fuller
Dave Winter
Technical Contributors
and Reviewers
Andrew Babb
Bharat Baddepudi
Maria Billings
Robert Carlin
Michael Cebulla
Nilesh Choudhury
Christian Craft
Ravindra Dani
Aslam Edah-Tally
Boris Erlikhman
Amit Ganesh
Ed Gilowski
Joel Goodman
Scott Gossett
Jim Hall
Roger Hansen
James He
David Hitchcock
Bill Hodak
Vimala Jacob
Martin Jensen
Kevin Jernigan
Caroline Johnston
Larry Justice
Vikram Kapoor
Bruce Kyro
Sumeet Lahorani
Publishers
Sujatha Nagendra
Giri Venugopal
Sue Lee
Juan Loaiza
Barb Lundhild
Varun Malhotra
Louis Nagode
Dan Norris
Michael Nowak
Sriram Palapudi
Umesh Panchaksharaiah
Sugam Pandey
Robert Pastijn
Marshall Presser
Georg Schmidt
Akshay Shah
Kam Shergill
Tim Shelter
Eric Siglin
Sundararaman Sridharan
Vijay Sridharan
Mahesh Subramaniam
Lawrence To
Alex Tsukerman
Kodi Umamageswaran
Douglas Utzig
Harald van Breederode
Mark Van de Wiel
Dave Winter
iii
Contents
1 Introduction
Course Objectives 1-2
Audience and Prerequisites 1-3
Course Scope 1-4
Course Contents 1-5
Terminology 1-6
Additional Resources 1-7
Practice 1 Overview: Introducing the Laboratory Environment 1-8
2 Exadata Overview
Objectives 2-2
Traditional Enterprise Database Storage Deployment 2-3
Exadata Storage Deployment 2-4
Exadata Implementation Architecture Overview 2-6
Introducing Exadata 2-7
Exadata Hardware Details (Sun Fire X4270 M2) 2-8
Exadata Specifications 2-9
InfiniBand Network 2-10
Classic Database I/O and SQL Processing Model 2-11
Exadata Smart Scan Model 2-12
Exadata Smart Storage Capabilities 2-13
Exadata Smart Scan Scale-Out Example 2-16
Exadata Hybrid Columnar Compression 2-19
Exadata Hybrid Columnar Compression Architecture Overview 2-20
Exadata Smart Flash Cache 2-21
Exadata Storage Index 2-23
Storage Index with Partitions Example 2-25
Database File System 2-26
I/O Resource Management 2-27
Benefits Multiply 2-28
Exadata Key Benefits for Data Warehousing 2-29
Exadata Key Benefits for OLTP 2-31
Quiz 2-32
Summary 2-34
iv
Additional Resources 2-35
Practice 2 Overview: Introducing Exadata Features 2-36
3 Exadata Architecture
Objectives 3-2
Exadata Software Architecture Overview 3-3
Exadata Software Architecture Details 3-5
Exadata Smart Flash Cache Architecture 3-7
Exadata Monitoring Architecture 3-9
Disk Storage Entities and Relationships 3-10
Interleaved Grid Disks 3-12
Flash Storage Entities and Relationships 3-13
Disk Group Configuration 3-14
Quiz 3-15
Summary 3-17
Additional Resources 3-18
Practice 3 Overview: Introducing Exadata Cell Architecture 3-19
4 Exadata Configuration
Objectives 4-2
Exadata Installation and Configuration Overview 4-3
Initial Network Preparation 4-4
Configuration of New Exadata Servers 4-6
Answering Questions During the Initial Boot Sequence 4-7
Exadata Administrative User Accounts 4-11
Configuring a New Exadata Cell 4-12
Important I/O Metrics for Oracle Databases 4-13
Testing Performance Using CALIBRATE 4-14
Configuring the Exadata Cell Server Software 4-15
Creating Cell Disks 4-16
Creating Grid Disks 4-17
Creating Flash-Based Grid Disks 4-18
Configuring Hosts to Access Exadata Cells 4-19
Configuring ASM and Database Instances for Exadata 4-20
Configuring ASM Disk Groups for Exadata 4-21
Optional Configuration Tasks 4-22
Exadata Storage Security Overview 4-23
Exadata Storage Security Implementation 4-24
Quiz 4-26
Summary 4-29
v
Additional Resources 4-30
Practice 4 Overview: Configuring Exadata 4-31
5 Exadata Performance Monitoring and Maintenance
Objectives 5-2
Monitoring Overview 5-3
Exadata Metrics and Alerts Architecture 5-4
Monitoring Exadata with Metrics 5-6
Monitoring Exadata with Metrics: Example 5-8
Monitoring Exadata with Alerts 5-9
Displaying Alert Examples 5-11
Monitoring Exadata with Active Requests 5-13
Monitoring SQL Execution Plans 5-14
Smart Scan Execution Plan Example 5-15
Predicate Offloading Considerations 5-16
Monitoring Exadata from Your Database 5-17
Monitoring Exadata with Wait Events 5-18
Monitoring Exadata with Enterprise Manager 5-19
Additional Monitoring Tools and Utilities 5-20
Cell Maintenance Overview 5-21
Automated Cell Maintenance Operations 5-23
Replacing a Damaged Physical Disk 5-24
Replacing a Damaged Flash Card 5-26
Moving All Disks from One Cell to Another 5-27
Using the Exadata Software Rescue Procedure 5-28
Quiz 5-30
Summary 5-32
Additional Resources 5-33
Practice 5 Overview: Monitoring Exadata 5-34
6 Exadata and I/O Resource Management
Objectives 6-2
I/O Resource Management Overview 6-3
I/O Resource Management Concepts 6-5
I/O Resource Management Plans 6-6
IORM Architecture 6-7
I/O Resource Management Plans Example 6-8
Enabling Intradatabase Resource Management 6-11
Intradatabase Plan Example 6-12
Enabling IORM for Multiple Databases 6-13
Interdatabase Plan Example 6-14
剩余165页未读,继续阅读
robinsontan
- 粉丝: 1
- 资源: 6
上传资源 快速赚钱
- 我的内容管理 收起
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
会员权益专享
最新资源
- stc12c5a60s2 例程
- Android通过全局变量传递数据
- c++校园超市商品信息管理系统课程设计说明书(含源代码) (2).pdf
- 建筑供配电系统相关课件.pptx
- 企业管理规章制度及管理模式.doc
- vb打开摄像头.doc
- 云计算-可信计算中认证协议改进方案.pdf
- [详细完整版]单片机编程4.ppt
- c语言常用算法.pdf
- c++经典程序代码大全.pdf
- 单片机数字时钟资料.doc
- 11项目管理前沿1.0.pptx
- 基于ssm的“魅力”繁峙宣传网站的设计与实现论文.doc
- 智慧交通综合解决方案.pptx
- 建筑防潮设计-PowerPointPresentati.pptx
- SPC统计过程控制程序.pptx
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
评论0