PART I
Features and Foundations
1 Oracle and Tightly Integrated Hardware and Software Platforms
A History of Appliance-like Computing Solutions
Oracle’s Evolution Towards Integrated Hardware and Software
Oracle Exadata Database Machine Fundamental Concepts
Software Integration and the Oracle Exadata Database Machine
Impact of the Platform on Personnel
2 Oracle 11g Enterprise Edition Features
Data Integrity and Performance
RAC and the Exadata Database Machine
Partitioning and the Exadata Database Machine
How Do You Configure Parallel Execution?
How Can Data Guard Be Implemented?
What Types of Compression Does Oracle Support?
What Is Database Resource Manager?
How Does Database Resource Manager Work?
What Can Database Resource Manager Affect?
How Does Database Resource Manager Work with Exadata?
Other Oracle Database 11g Features
Monitoring Savings from Smart Scan
Exadata Hybrid Columnar Compression
What Is Exadata Hybrid Columnar Compression?
What Is the Exadata Smart Flash Cache?
How Can You Use the Exadata Smart Flash Cache?
How Does Exadata Smart Flash Cache Determine What Is Cached?
Exadata Smart Flash Cache Statistics
Benefits from Exadata Smart Flash Cache
Benefits from I/O Resource Manager
Interacting with Exadata Storage Server Software
Management Software Components
4 Oracle Exadata Database Machine Platform Hardware Components
Processor Speeds, Memory Capacity, and Storage
How Hardware Components Work Together
Oracle Exadata Database Machine Packaging Basics
Installation and Initial Deployment Considerations
Upgrade Choices for Existing Systems
Connecting to the Database Machine
Highly Available Hardware Considerations
5 Managing the Exadata Database Machine
Exadata Storage Server Architecture
Database Server Software Components
Exadata Storage Server Software Components
Exadata Storage Server Administration
Exadata Storage Server OS Users and Privileges
Exadata Storage Server Security Configuration
Exadata Storage Server Monitoring
Monitoring with Metrics and Alerts
Monitor Using the Oracle Database
Monitoring with Oracle Enterprise Manager
Oracle Integrated Lights Out Manager
6 High Availability and Backup Strategies
Exadata Maximum Availability Architecture (MAA)
High Availability with Oracle Data Guard
Using Oracle GoldenGate with Database Machine
Database Machine Patches and Upgrades
Exadata Storage Server High Availability
Exadata Database Machine Backup and Recovery Best Practices
Oracle Database Backup Strategy
Database Recovery Best Practices
7 Deploying Data Warehouses on the Oracle Exadata Database Machine
Generic Oracle Query Optimization
SQL Aggregation and Analytics Extensions
Unique Exadata Features for Optimal Query Response
Data Warehousing Compression Techniques
Best Practices for Data Loading
Partitioning, Backups, and High Availability in Data Warehouses
Data Models, Business Intelligence Tools, and Security
Sizing the Platform for Data Warehousing and Justifying Purchase
OLTP Workloads and Exadata Features
General Hardware and Infrastructure Considerations
9 Consolidating Databases with the Oracle Exadata Database Machine
How the Oracle Exadata Database Machine Helps Consolidation
Workload Consolidation and Isolation
Overprovisioning Consolidation
10 Migrating to the Exadata Database Machine
Discovering the Current Environment
Database Machine Capacity Planning and Sizing
Migration Steps for Non-Oracle Databases
Data Migration and Synchronization
Using Automated Tools for Migration
Migration Steps for Oracle Databases
Migrating Using Physical Methods
Migrating Using Logical Methods
A Exadata Capacity and Performance Specifications
Exadata Database Machine Storage Capacity