Oracle Exadata: Architecture and internals technical deep dive
summary
Exadata moves predicates to storage and returns only needed columns, implementing Row Filtering and Column Projection, verified by AWR and SQL Monitor. Storage Index keeps per-1MB min/max and bloom filters to skip IOs (example: 588GB scanned, 252GB saved; another case 173GB → 49MB, ~3,000x reduction). Flash cache stores columnar formats for vectorized processing (664GB processed, 445GB avoided). Persistent-memory RDMA yields sub-19µs single-block reads and >2 million IO/s to a storage server at near 0% CPU.
AI-written summary · about
chapters (5)
- 0:00Start
- 4:13Cloud Storage Bottleneck
- 5:06Traditional Scan
- 10:57Advances in Storage Index
- 15:37Superior OLTP Architecture - Memory Cache Acceleration
related talks
19mSpeed up transparent performance with Exadata: What, when, how, and why
32mExadata: New features and functionality
24mFuture of Data and AI
27mDatabase In-Memory: Real-time analytics, supercharged
19mMission-critical databases made simple
13mOptimizing Oracle Database for Multicloud
18mNext Gen Data Architecture for Multicloud
24mOracle's vision for simplifying data-driven apps and analytics
