External Resources
A list of resources that I frequently refer to and point others to:
Indexes
Richard Foote: Index Internals Rebuilding The Truth
Jonathan Lewis: Unbalanced Indexes
Locking inc Unindexed Foreign Keys
Mark Bobak: Understanding and Interpreting Deadlocks(no longer available)
Interpreting LMD Global Wait-for-Graph
Tom Kyte on unindexes foreign keys
Jonathan Lewis: Lock Horror
Jonathan Lewis: Lock Modes
Richard Foote: New Locking Modes When Policing FKs
Statspack Interpretation (and therefore AWR)
Connie Dialeris Green: Diagnosing Performance Bottlenecks using Statspack and The Oracle Performance Method
Jonathan Lewis – Collection of Statspack and AWR resources
Pipelined Table Functions
Adrian Billington: Improving Performance with Pipelined Table Functions
“The EAV model” – what is it good for? Absolutely Nothing. Say it Again.
Tom Ktye: EAV
Tim Gorman – Bad CRMa
Consistent Gets
Mark Bobak: Difference between db block get and consistent get
Stats
Greg Rahn: Choosing An Optimal Stats Gathering Strategy
Partitioning
Tim Gorman: Scaling To Infinity
Jonathan Lewis: Local Indexes – prefixed vs nonprefixed
Doug Burns: Partitioning and Statistics
Parallel
Doug Burns: How many Slaves?
Doug Burns: Tuning Parallel Execution
Doug Burns: Suck it Dry
Scheduler
Ronald Rood: Job Queue Processes and the Scheduler
The explanations of Billy Verreynne
On SQL and PLSQL
Exadata
Kevin Closson: Seven Fundamentals
By Example
Dynamic Pivot Query – Anton Scheffer
Tabibitosan method tutorial by Aketi Jyuuzou
Uekisan method tutorial by Aketi Jyuuzou
Extended SQL Trace
Miladin Modrakovic: Event SQL_TRACE in 11g
Tanel Poder: Oradebug Doc
Log File Sync
Kevin Closson: log file sync
Bart Sjerps – Redo log performance
SSD
Gwen Shapira: De-Confusing SSD
Kevin Closson: Leave redo where it belongs
Guy Harrison: Using flash disk for Redo on Exadata
Guy Harrison: Evaluating the options for Exploiting SSD
Result Cache:
Uwe Hesse: Result Cache (in particular see comments)
Alex Fatkulin: Result Cache Scability 11gR1 I
Alex Fatkulin: Result Cache Scability 11gR1 II
Alex Fatkulin: Result Cache Scalability 11gR2
Alex Fatkulin: Shared mode gets in 11gR2
Block Size
Jonathan Lews: Block Sizes
Jonathan Lewis: Copy of OTN forum thread
Greg Rahn: Understanding performance
Greg Rahn: DB FILE MULTIBLOCK READ COUNT
Charles Hooper: Fault Quotes 5: Block Sizes
Oracle forums: Optimal block size
Tom Kyte:
Not using ORA_ROWSCN for optimistic locking
Recent Comments