Exadata

• 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