~/talk

Oracle Exadata: Architecture and internals technical deep dive

Talkat Oracle CloudWorld 2022 · 2022-10-17..10-20· [databases]
links:none on file
slides:none on file

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

  1. 0:00Start
  2. 4:13Cloud Storage Bottleneck
  3. 5:06Traditional Scan
  4. 10:57Advances in Storage Index
  5. 15:37Superior OLTP Architecture - Memory Cache Acceleration
~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.