Investigations

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
7. correlation_nocorrelation_ext_stats
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
13. Library_cache_locks_and_library_cache_pin_waits
14. resolving_corruption_issue_with_filehdr_dumps
15. ora-4031_and_shared_pool_duration
16. Shared pool free lists and duration .
17. plan_hash_value_and_gc.