Oracle Exadata Performance: Latest Improvements and Less Known Features
About index range scans, disk re-reads and how your new car can go 600 miles per hour!
Combining Bloom Filter Offloading and Storage Indexes on Exadata
Where does the Exadata storage() predicate come from?
cell flash cache read hits vs. cell writes to flash cache statistics on Exadata
Hard Drive Predictive Failures on Linux and Exadata
When do Oracle Parallel Execution Slaves issue buffered physical reads – Part 2?
When do Oracle Parallel Execution Slaves issue buffered physical reads – Part 1?
Oracle Performance & Troubleshooting Online Seminars in 2013
Scalar Subqueries in Oracle SQL WHERE clauses (and a little bit of Exadata stuff too)
Forcing Smart Scans on Exadata – is the _serial_direct_read parameter safe to use in production?
List Exadata Storage Cell disk summary with cellpd.sql and cellpdx.sql scripts
List Exadata Disk Layout and Topology with the exadisktopo scripts
V$CELL_THREAD_HISTORY – “ASH” for Exadata Storage Cells
Listing Exadata storage cells and their configuration info from V$CELL_CONFIG
ExaSnapper 0.7 beta download and the hacking session videos
Drilling Deep Into Exadata Performance with ASH, SQL Monitoring and Exadata Snapper – slides and a hacking session!
Select statement generating redo – and lost write detection
Optimizer statistics-driven direct path read decision for full table scans (_direct_read_decision_statistics_driven)
MOATS-like sqlplus “top” utility for RAC
Exadata Smart Scan predicate offloading and sequence.NEXTVAL