Few of my blogs will be presented here as pdf files.
1. tuning_log_file_sync_waits Blog discussion about tuning ‘log file sync’ waits
2. resolving-hw-enqueue-contention Investigation about HW enqueue contention
3. resolving-latch-contention-cbc Investigation about latch contention cache buffers chains latches
4. High CPU usage SYS mode
5. Investigations: Performance and hugepages
6. Investigations: extended stats and multi-column correlation
8. cardinality feedback and latch contention
9. Investigations: A stroll through shared pool
10. Investigations: High global cache waits on tab$
11. Investigations:Systemstate dump analysis for high intensive nocache sequences
12. Investigations:Dynamic plan table, x$kqlfxpl, and library cache latch
16. Shared pool free lists and duration .
18. Query Transformation part 1 .
19. gc buffer busy waits_orainternals.pdf