Achieving Extreme Performance with Oracle Exadata

Contents......Page 12
Foreword......Page 20
Acknowledgments......Page 22
Introduction......Page 24
Part I: Features and Foundations......Page 26
1 Oracle and Tightly Integrated Hardware and Software Platforms......Page 28
A History of Appliance-Like Computing Solutions......Page 30
Oracle’s Evolution Towards Integrated Hardware and Software......Page 32
Oracle Exadata Database Machine Fundamental Concepts......Page 35
Software Integration and the Oracle Exadata Database Machine......Page 38
Impact of the Platform on Personnel......Page 40
Future Directions......Page 42
Summary......Page 43
2 Oracle 11g Enterprise Edition Features......Page 44
Data Integrity and Performance......Page 45
Real Application Clusters......Page 52
Automatic Storage Management......Page 62
Partitioning......Page 66
Parallel Execution......Page 72
Data Guard......Page 88
Compression......Page 92
Database Resource Manager......Page 94
Analysis Capabilities......Page 98
Enterprise Manager......Page 99
Data Movement......Page 102
Operating Systems......Page 104
Other Oracle Database 11g Features......Page 105
Summary......Page 109
3 Exadata Software Features......Page 112
Smart Scan......Page 114
Other Offloaded Processing......Page 121
Exadata Hybrid Columnar Compression......Page 124
Storage Indexes......Page 129
Exadata Smart Flash Cache......Page 132
I/O Resource Manager......Page 137
Interacting with Exadata Storage Server Software......Page 143
Summary......Page 148
4 Oracle Exadata Database Machine Platform Hardware Components......Page 150
Latency and Balance......Page 151
Oracle Exadata Database Machine Packaging Basics......Page 155
Installation and Initial Deployment Considerations......Page 162
Upgrade Choices for Existing Systems......Page 165
Connecting to the Database Machine......Page 166
Highly Available Hardware Considerations......Page 168
Summary......Page 169
Part II: Best Practices......Page 172
5 Managing the Exadata Database Machine......Page 174
Exadata Storage Server Architecture......Page 176
Exadata Storage Server Administration......Page 187
Exadata Storage Server Monitoring......Page 204
Summary......Page 232
6 High Availability and Backup Strategies......Page 234
Exadata Maximum Availability Architecture (MAA)......Page 235
Exadata Database Machine Backup and Recovery Best Practices......Page 263
Summary......Page 284
7 Deploying Data Warehouses on the Oracle Exadata Database Machine......Page 286
Data Warehousing Basics......Page 288
Generic Oracle Query Optimization......Page 293
Embedded Analytics in Oracle......Page 296
Unique Exadata Features for Optimal Query Response......Page 300
Data Warehousing Compression Techniques......Page 303
The Typical Life of a Query......Page 304
Best Practices for Data Loading......Page 305
Partitioning, Backups, and High Availability in Data Warehouses......Page 307
Data Models, Business Intelligence Tools, and Security......Page 308
Sizing the Platform for Data Warehousing and Justifying Purchase......Page 312
Summary......Page 315
8 Exadata and OLTP......Page 318
OLTP Workloads and Exadata Features......Page 319
Exadata Hardware and OLTP......Page 321
Oracle 11g and OLTP......Page 326
Exadata Software and OLTP......Page 335
Exadata Nodes and OLTP......Page 336
Exadata as a Complete System......Page 337
Summary......Page 338
9 Consolidating Databases with the Oracle Exadata Database Machine......Page 340
Why Consolidate?......Page 341
How the Oracle Exadata Database Machine Helps Consolidation......Page 342
Database Server Consolidation......Page 343
Workload Consolidation and Isolation......Page 350
Meeting and Exceeding SLAs......Page 354
Consolidation Design......Page 363
Summary......Page 367
10 Migrating to the Exadata Database Machine......Page 368
Premigration Steps......Page 370
Migration Steps for Non-Oracle Databases......Page 389
Migration Steps for Oracle Databases......Page 399
Summary......Page 409
A: Exadata Capacity and Performance Specifications......Page 410
Exadata Database Machine Storage Capacity......Page 411
Exadata Storage Server Performance......Page 412
A......Page 414
B......Page 415
C......Page 416
D......Page 417
E......Page 420
G......Page 421
I......Page 422
L......Page 423
M......Page 424
O......Page 425
P......Page 427
R......Page 429
S......Page 430
W......Page 432
Z......Page 433