Book description
Oracle Exadata Recipes takes an example-based, problem/solution approach in showing how to size, install, configure, manage, monitor, optimize, and migrate Oracle database workloads on and to the Oracle Exadata Database Machine. Whether you're an Oracle Database administrator, Unix/Linux administrator, storage administrator, network administrator, or Oracle developer, Oracle Exadata Recipes provides effective and proven solutions to accomplish a wide variety of tasks on the Exadata Database Machine. You can feel confident using the reliable solutions that are demonstrated in this book in your enterprise Exadata environment.
Managing Oracle Exadata is unlike managing a traditional Oracle database. Oracle's Exadata Database Machine is a pre-configured engineered system comprised of hardware and software, built to deliver extreme performance for Oracle Database workloads. Exadata delivers extreme performance by offering an optimally balanced hardware infrastructure with fast components at each layer of the engineered technology stack, as well as a unique set of Oracle software features designed to leverage the high-performing hardware infrastructure by reducing I/O demands. Let Oracle Exadata Recipes help you translate your existing Oracle Database knowledge into the exciting new growth area that is Oracle Exadata.
Helps extend your Oracle Database skillset to the fast-growing, Exadata platform
Presents information on managing Exadata in a helpful, example-based format
Clearly explains unique Exadata software and hardware features
What you'll learn
Install and configure Exadata
Manage your Exadata hardware infrastructure
Monitor and troubleshoot performance issues
Manage smart scan and cell offload processing
Take advantage of Hybrid Columnar Compression
Deploy Smart Flash Cache and Smart Flash Logging
Ensure the health of your Exadata environment
Who this book is for
Oracle Exadata Recipes is for Oracle Database administrators, Unix/Linux administrators, storage administrators, backup administrators, network administrators, and Oracle developers who want to quickly learn to develop effective and proven solutions without reading through a lengthy manual scrubbing for techniques. Readers in a hurry will appreciate the recipe format that sets up solutions to common tasks as the centerpiece of the book.
Table of contents
- Title Page
- Dedication
- Contents at a Glance
- Contents
- About the Author
- About the Technical Reviewer
- Acknowledgments
- Introduction
-
Part 1: Exadata Architecture
-
Chapter 1: Exadata Hardware
- 1-1. Identifying Exadata Database Machine Components
- 1-2. Displaying Storage Server Architecture Details
- 1-3. Displaying Compute Server Architecture Details
- 1-4. Listing Disk Storage Details on the Exadata Storage Servers
- 1-5. Listing Disk Storage Details on the Compute Servers
- 1-6. Listing Flash Storage on the Exadata Storage Servers
- 1-7. Gathering Configuration Information for the InfiniBandSwitches
-
Chapter 2: Exadata Software
- 2-1. Understanding the Role of Exadata Storage Server Software
- 2-2. Validating Oracle 11gR2 Databases on Exadata
- 2-3. Validating Oracle 11gR2 Grid Infrastructure on Exadata
- 2-4. Locating the Oracle Cluster Registry and Voting Disks on Exadata
- 2-5. Validating Oracle 11gR2 Real Application Clusters Installation and Database Storage on Exadata
- 2-6. Validating Oracle 11gR2 Real Application Clusters Networking on Exadata
-
Chapter 3: How Oracle Works on Exadata
- 3-1. Mapping Physical Disks, LUNs, and Cell Disks on the Storage Servers
- 3-2. Mapping ASM Disks, Grid Disks, and Cell Disks
- 3-3. Mapping Flash Disks to Smart Flash Storage
- 3-4. Identifying Cell Server Software Processes
- 3-5. Tracing Oracle I/O Requests on Exadata Compute Nodes
- 3-6. Validating That Your Oracle RAC Interconnect Is Using InfiniBand
- 3-7. Tracing cellsrv on the Storage Servers
-
Chapter 1: Exadata Hardware
-
Part 2: Preparing for Exadata
- Chapter 4: Workload Qualification
-
Chapter 5: Sizing Exadata
- 5-1. Determining CPU Requirements
- 5-2. Determining IOPs Requirements
- 5-3. Determining I/O Bandwidth Requirements
- 5-4. Determining ASM Redundancy Requirements
- 5-5. Forecasting Storage Capacity
- 5-6. Planning for Database Growth
- 5-7. Planning for Disaster Recovery
- 5-8. Planning for Backups
- 5-9. Determining Your Fast Recovery Area and RECO Disk Group Size Requirements
-
Chapter 6: Preparing for Exadata
- 6-1. Planning and Understanding Exadata Networking
- 6-2. Configuring DNS
- 6-3. Running checkip.sh
- 6-4. Customizing Your InfiniBand Network Configuration
- 6-5. Determining Your DATA and RECO Storage Requirements
- 6-6. Planning for ASM Disk Group Redundancy
- 6-7. Planning Database and ASM Extent Sizes
- 6-8. Completing the Pre-Delivery Survey
- 6-9. Completing the Configuration Worksheet
-
Part 3: Exadata Administration
-
Chapter 7: Administration and Diagnostics Utilities
- 7-1. Logging in to the Exadata Compute and Storage Cells Using SSH
- 7-2. Configuring SSH Equivalency
- 7-3. Locating Key Configuration Files and Directories on the Cell Servers
- 7-4. Locating Key Configuration Files and Directories on the Compute Nodes
- 7-5. Starting and Stopping Cell Server Processes
- 7-6. Administering Storage Cells Using CellCLI
- 7-7. Administering Storage Cells Using dcli
- 7-8. Generating Diagnostics from the ILOM Interface
- 7-9. Performing an Exadata Health Check Using exachk
- 7-10. Collecting Compute and Cell Server Diagnostics Using the sundiag.sh Utility
- 7-11. Collecting RAID Storage Information Using the MegaCLI utility
- 7-12. Administering the Storage Cell Network Using ipconf
- 7-13. Validating Your InfiniBand Switches with the CheckSWProfile.sh Utility
- 7-14. Verifying Your InfiniBand Network Topology
- 7-15. Diagnosing Your InfiniBand Network
- 7-16. Connecting to Your Cisco Catalyst 4948 Switch and Changing Switch Configuration
-
Chapter 8: Backup and Recovery
- 8-1. Backing Up the Storage Servers
- 8-2. Displaying the Contents of Your CELLBOOT USB Flash Drive
- 8-3. Creating a Cell Boot Image on an External USB Drive
- 8-4. Backing Up Your Compute Nodes Using Your Enterprise Backup Software
- 8-5. Backing Up the Compute Servers Using LVM Snapshots
- 8-6. Backing Up Your Oracle Databases with RMAN
- 8-7. Backing Up the InfiniBand Switches
- 8-8. Recovering Storage Cells from Loss of a Single Disk
- 8-9. Recovering Storage Cells from Loss of a System Volume Using CELLBOOT Rescue
- 8-10. Recovering from a Failed Storage Server Patch
- 8-11. Recovering Compute Server Using LVM Snapshots
- 8-12. Reimaging a Compute Node
- 8-13. Recovering Your InfiniBand Switch Configuration
- 8-14. Recovering from Loss of Your Oracle Cluster Registry and Voting Disks
-
Chapter 9: Storage Administration
- 9-1. Building ASM Disk Groups on Exadata
- 9-2. Properly Configuring ASM Disk Group Attributes on Exadata
- 9-3. Identifying Unassigned Grid Disks
- 9-4. Configuring ASM Redundancy on Exadata
- 9-5. Displaying ASM Partner Disk Relationships on Exadata
- 9-6. Measuring ASM Extent Balance on Exadata
- 9-7. Rebuilding Cell Disks
- 9-8. Creating Interleaved Cell Disks and Grid Disks
- 9-9. Rebuilding Grid Disks
- 9-10. Setting smart_scan_capable on ASM Disk Groups
- 9-11. Creating Flash Grid Disks for Permanent Storage
-
Chapter 10: Network Administration
- 10-1. Configuring the Management Network on the Compute Nodes
- 10-2. Configuring the Client Access Network
- 10-3. Configuring the Private Interconnect on the Compute Nodes
- 10-4. Configuring the SCAN Listener
- 10-5. Managing Grid Infrastructure Network Resources
- 10-6. Configuring the Storage Server Ethernet Network
- 10-7. Changing IP Addresses on Your Exadata Database Machine
-
Chapter 11: Patching and Upgrades
- 11-1. Understanding Exadata Patching Definitions, Alternatives, and Strategies
- 11-2. Preparing to Apply Exadata Patches
- 11-3. Patching Your Exadata Storage Servers
- 11-4. Patching Your Exadata Compute Nodes and Databases
- 11-5. Patching the InfiniBand Switches
- 11-6. Patching Your Enterprise Manager Systems Management Software
- Chapter 12: Security
-
Chapter 7: Administration and Diagnostics Utilities
-
Part 4: Monitoring Exadata
-
Chapter 13: Monitoring Exadata Storage Cells
- 13-1. Monitoring Storage Cell Alerts
- 13-2. Monitoring Cells with Active Requests
- 13-3. Monitoring Cells with Metrics
- 13-4. Configuring Thresholds for Cell Metrics
- 13-5. Using dcli with Special Characters
- 13-6. Reporting and Summarizing metrichistory Using R
- 13-7. Reporting and Summarizing metrichistory Using Oracle and SQL
- 13-8. Detecting Cell Disk I/O Bottlenecks
- 13-9. Measuring Small I/O vs. Large I/O Requests
- 13-10. Detecting Grid Disk I/O Bottlenecks
- 13-11. Detecting Host Interconnect Bottlenecks
- 13-12. Measuring I/O Load and Waits per Database, Resource Consumer Group, and Resource Category
-
Chapter 14: Host and Database Performance Monitoring
- 14-1. Collecting Historical Compute Node and Storage Cell Host Performance Statistics
- 14-2. Displaying Real-Time Compute Node and Storage Cell Performance Statistics
- 14-3. Monitoring Exadata with Enterprise Manager
- 14-4. Monitoring Performance with SQL Monitoring
- 14-5. Monitoring Performance by Database Time
- 14-6. Monitoring Smart Scans by Database Time and AAS
- 14-7. Monitoring Exadata with Wait Events
- 14-8. Monitoring Exadata with Statistics and Counters
- 14-9. Measuring Cell I/O Statistics for a SQL Statement
-
Chapter 13: Monitoring Exadata Storage Cells
-
Part 5: Exadata Software
-
Chapter 15: Smart Scan and Cell Offload
- 15-1. Identifying Cell Offload in Execution Plans
- 15-2. Controlling Cell Offload Behavior
- 15-3. Measuring Smart Scan with Statistics
- 15-4. Measuring Offload Statistics for Individual SQL Cursors
- 15-5. Measuring Offload Efficiency
- 15-6. Identifying Smart Scan from 10046 Trace Files
- 15-7. Qualifying for Direct Path Reads
- 15-8. Influencing Exadata’s Decision to Use Smart Scans
- 15-9. Identifying Partial Cell Offload
- 15-10. Dealing with Fast Object Checkpoints
-
Chapter 16: Hybrid Columnar Compression
- 16-1. Estimating Disk Space Savings for HCC
- 16-2. Building HCC Tables and Partitions
- 16-3. Contrasting Oracle Compression Types
- 16-4. Determining the Compression Type of a Segment
- 16-5. Measuring the Performance Impact of HCC for Queries
- 16-6. Direct Path Inserts into HCC Segments
- 16-7. Conventional Inserts to HCC Segments
- 16-8. DML and HCC
- 16-9. Decompression and the Performance Impact
-
Chapter 17: I/O Resource Management and Instance Caging
- 17-1. Prioritizing I/O Utilization by Database
- 17-2. Limiting I/O Utilization for Your Databases
- 17-3. Managing Resources within a Database
- 17-4. Prioritizing I/O Utilization by Category of Resource Consumers
- 17-5. Prioritizing I/O Utilization by Categories of Resource Consumers and Databases
- 17-6. Monitoring Performance When IORM Is Enabled
- 17-7. Obtaining IORM Plan Information
- 17-8. Controlling Smart Flash Cache and Smart Flash Logging with IORM
- 17-9. Limiting CPU Resources with Instance Caging
-
Chapter 18: Smart Flash Cache and Smart Flash Logging
- 18-1. Managing Smart Flash Cache and Smart Flash Logging
- 18-2. Determining Which Database Objects Are Cached
- 18-3. Determining What’s Consuming Your Flash Cache Storage
- 18-4. Determining What Happens When Querying Uncached Data
- 18-5. Measuring Smart Flash Cache Performance
- 18-6. Pinning Specific Objects in Smart Flash Cache
- 18-7. Quantifying Benefits of Smart Flash Logging
-
Chapter 19: Storage Indexes
- 19-1. Measuring Performance Impact of Storage Indexes
- 19-2. Measuring Storage Index Performance with Not-So-Well-Ordered Data
- 19-3. Testing Storage Index Behavior with Different Query Predicate Conditions
- 19-4. Tracing Storage Index Behavior
- 19-5. Tracing Storage Indexes When More than Eight Columns Are Referenced
- 19-6. Tracing Storage Indexes when DML Is Issued against Tables
- 19-7. Disabling Storage Indexes
- 19-8. Troubleshooting Storage Indexes
-
Chapter 15: Smart Scan and Cell Offload
-
Part 6: Post Implementation Tasks
- Chapter 20: Post-Installation Monitoring Tasks
-
Chapter 21: Post-Install Database Tasks
- 21-1. Creating a New Oracle RAC Database on Exadata
- 21-2. Setting Up a DBFS File System on Exadata
- 21-3. Configuring HugePages on Exadata
- 21-4. Configuring Automatic Degree of Parallelism
- 21-5. Setting I/O Calibration on Exadata
- 21-6. Measuring Impact of Auto DOP and Parallel Statement Queuing
- 21-7. Measuring Auto DOP and In-Memory Parallel Execution
- 21-8. Gathering Optimizer Statistics on Exadata
- Index
Product information
- Title: Oracle Exadata Recipes: A Problem-Solution Approach
- Author(s):
- Release date: January 2013
- Publisher(s): Apress
- ISBN: 9781430249146
You might also like
book
Oracle Database 11g Performance Tuning Recipes: A Problem-Solution Approach
Performance problems are rarely "problems" per se. They are more often "crises" during which you're pressured …
book
RMAN Recipes for Oracle Database 12c: A Problem-Solution Approach, Second Edition
RMAN Recipes for Oracle Database 12c is an example-driven approach to the Oracle database administrator's #1 …
book
Oracle SQL Recipes: A Problem-Solution Approach
Have you ever been faced with a new type of query to write, or been asked …
book
Oracle GoldenGate 11g Complete Cookbook
Dig deep into administering Oracle Goldengate 11g using this comprehensive cookbook. From the very basics of …