Understanding Oracle Performance.
Beyond the Execution Plan.
Deep dives into Oracle optimizer internals, Exadata, SQL tuning and real-world performance problems.
“Always be yourself. Unless you can be a tuning freak or windsurfer. Then always be one of them.”
About Me
ORACLE ACE · PERFORMANCE TUNING CONSULTANT · CONFERENCE SPEAKER
Below is AI-generated (still mainly true). I’ll add a human touch soon.
I’m an Oracle Performance Tuning specialist with over 25 years of experience, working primarily with large enterprise database environments in the banking and transportation industries.
For more than 15 years, I’ve been working extensively with Oracle Exadata, focusing on SQL/PLSQL performance, Cost-Based Optimizer internals, Smart Scan, Storage Indexes, and complex performance troubleshooting.
My particular interest is understanding why Oracle behaves the way it does — going beyond execution plans into optimizer traces, wait events, and database internals to identify the real causes of performance problems.
Beyond consulting, I regularly share my experience through technical articles, conference presentations, and Oracle Performance Tuning workshops.
All Technical Articles
Explore by Topic
10046 trace 10053 trace 10200 Trace Auto SQL Plan Management AVG_LEAF_BLOCKS_PER_KEY Batched I/O cardinality Cartesian Join CBO costing CDB / PDB CLUF Clustering Factor Converting of CPU costing in 10053 CPU_COST in 10053 trace Exadata FC HBA utilization Hard Parsing Hash Join index leaf block dump index tree dump Join Permutations large SGA LRU Nested Loop NSMTIO OEM Offload ORA-04031 Oracle 23ai Oracle tuning oradebug Parallel Query Performance Tuning Resc Resp smart scan SQL baseline SQL Monitor SQL Plan SQL Trace SQL Translation Framework SQL Tuning system statistics Tuning in Multitenant Architecture Why Offload does not kick in