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 10046 event 10046 trace 10053 10053 event 10053 trace 10200 event Active Session History Analysis of costing of joins in 10053 AUTOTRACE AVG_DATA_BLOCKS_PER_KEY AVG_LEAF_BLOCKS_PER_KEY Batched I/O buffer cache cardinality Cartesian Join CBO CBO 10053 trace CBO costing CLUF Clustering Factor Converting of CPU costing in 10053 Cost Based Optimizer CPU CPU_COST in 10053 trace Exadata FC HBA utilization FC host Flash Flash disk FTS Full Table Scan Hash Join HBA I/O throughput index leaf block dump Index Range Scan index tree dump large SGA Linux LRU Nested Loop NSMTIO Offload optimizer Oracle CBO Oracle performance Oracle Performance Tuning Oracle SQL optimization Oracle tuning oradebug Parallel Query Performance Tuning Resc Resp session_trace_enable smart scan Sort Merge Join SQL Performance Tuning SQL Plan SQL Tuning sql_id system statistics Temp tablespace