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 Analysis of costing of joins in 10053 Auto SQL Plan Management AVG_DATA_BLOCKS_PER_KEY AVG_LEAF_BLOCKS_PER_KEY Batched I/O Cartesian Join CBO costing 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 large SGA Linux LRU Nested Loop NSMTIO Offload Oracle 23ai Oracle performance Oracle tuning oradebug Parallel Query Performance Tuning Resc Resp smart scan Sort Merge Join SQL baseliine SQL baseline SQL Plan SQL Tuning sql_id system statistics Temp tablespace