Piotr Sajda Oracle Tuning Blog

Always be yourself.
Unless you can be tuning freak or windsurfer.
Then always be one (of them).
This is Piotr’s Oracle Tuning Blog – you’re welcome.

With 20 years of Oracle performance tuning experience and just as many years of windsurfing, I’m probably the best windsurfer among the Ora-tuning geeks and definitely the most “out-there” Oracle ACE performance tuning specialist on the water!

Interested in tailored performance tuning workshops?
Please get in touch on piotr.sajda@gmail.com

All tags

10046 trace 10053 trace 10200 Trace Active Session History Auto SQL Plan Management AVG_DATA_BLOCKS_PER_KEY 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 FC host Flash Flash disk Hash Join HBA I/O throughput index leaf block dump index tree dump Join Permutations large SGA Linux LRU Nested Loop NSMTIO OEM Offload Oracle 23ai Oracle performance Oracle tuning oradebug Parallel Query Performance Tuning Resc Resp smart scan SQL baseline SQL Monitor SQL Plan SQL Tuning sql_id system statistics Temp tablespace Tuning in Multitenant Architecture Why Offload does not kick in