Home Page Icon
Home Page
Table of Contents for
Expert Oracle Exadata
Close
Expert Oracle Exadata
by Tanel Pöder, Randy Johnson, Kerry Osborne
Expert Oracle Exadata
Title
Contents at a Glance
Contents
About the Author
About the Technical Reviewer
Acknowledgments
Introduction
The Intended Audience
How We Came to Write This Book
A Moving Target
Thanks to the Unofficial Editors
Who Wrote That?
Online Resources
A Note on "Kevin Says"
How We Tested
Schemas and Tables
Good Luck
Chapter 1: What Is Exadata?
An Overview of Exadata
History of Exadata
Alternative Views of What Exadata Is
Configuration Options
Hardware Components
Software Components
Software Architecture
Summary
Chapter 2: Offloading / Smart Scan
Why Offloading Is Important
What Offloading Includes
Smart Scan Prerequisites
Smart Scan Disablers
How to Verify That Smart Scan is Happening
Parameters
Summary
Chapter 3: Hybrid Columnar Compression
Oracle Storage Review
Oracle Compression Mechanisms
HCC Mechanics
HCC Performance
Expected Compression Ratios
Restrictions/Challenges
Common Usage Scenarios
Summary
Chapter 4: Storage Indexes
Structure
Monitoring Storage Indexes
Controlling Storage Indexes
Behavior
Performance
Potential Issues
Summary
Chapter 5: Exadata Smart Flash Cache
Hardware
Cache vs. Flash Disk
Monitoring
Performance
Summary
Chapter 6: Exadata Parallel Operations
Parameters
Parallelization at the Storage Tier
Auto DOP
Parallel Statement Queuing
In-Memory Parallel Execution
Summary
Chapter 7: Resource Management
Database Resource Manager
Instance Caging
I/O Resource Manager
Summary
Chapter 8: Configuring Exadata
Exadata Network Components
About the Configuration Process
Configuring Exadata
Upgrading Exadata
Summary
Chapter 9: Recovering Exadata
Exadata Diagnostic Tools
Backing Up Exadata
Backing Up the Database
Recovering Exadata
Summary
Chapter 10: Exadata Wait Events
Events Specific to Exadata
Exadata Wait Events in the User I/O Class
Exadata Wait Events in the System I/O Class
Exadata Wait Events in the Other and Idle Classes
Old Events
Resource Manager Events
Summary
Chapter 11: Understanding Exadata Performance Metrics
Measuring Exadata's Performance Metrics
Revisiting the Prerequisites for Exadata Smart Scans
Exadata Dynamic Performance Counters
Understanding SQL Statement Performance
Summary
Chapter 12: Monitoring Exadata Performance
A Systematic Approach
Monitoring SQL Statement Response Time
Monitoring the Storage Cell Layer
Summary
Chapter 13: Migrating to Exadata
Migration Strategies
Logical Migration
Physical Migration
Backup and Restore
Summary
Chapter 14: Storage Layout
Exadata Disk Architecture
Creating Grid Disks
Storage Strategies
Cell Security
Summary
Chapter 15: Compute Node Layout
Provisioning Considerations
Non-RAC Configuration
RAC Clusters
Typical Exadata Configuration
Exadata Clusters
Summary
Chapter 16: Unlearning Some Things We Thought We Knew
A Tale of Two Systems
OLTP-Oriented Workloads
DW-Oriented Workloads
Mixed Workloads
Summary
Appendix A: CellCLI and dcli
CellCLI Command Syntax
dcli Command Syntax
Summary
Appendix B: Online Exadata Resources
Exadata MOS Support Notes
Helpful Exadata MOS Support Notes
Exadata Bulletins and Blogs
Appendix C: Diagnostic Scripts
Index
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Next
Next Chapter
Title
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset