Investigations

Our blog entries will be stored here in pdf format for easy reading. Enjoy!

1. RAC wait event gc cr disk read gc_cr_disk_read
2. What happens, internally, if you update a column to the same value? update to column value_v2
3. A deep review of shared pool components A_stroll_through_shared_pool
4. How to tune SQL statements scientifically? tuning-statements-scientifically
5. Dynamic plan table and library cache latch contention: dynamic_plan_table_with_library_cache_latch
6. Mix and match RAC and nocache sequences for a disaster: systemstate_dump_analysis_high_intensive_nocache_sequence
7. File header dumps to the rescue to resolve corruption: resolving_corruption_issue_with_filehdr_dumps
8. An intensive review of Library cache locks and pins Library_cache_locks_and_library_cache_pin_waits
9. Parallel Query, RAC, and udpsnoop RAC_parallel_query_and_udpsnoop
10. Shared pool durations can lead to ORA-4031: ora-4031_and_shared_pool_duration
11. Shared pool freelists and shared pool durations shared_pool_free_list_and_durations
12. All about plan hash value plan_hash_value_and_gc
13. A complex feature in RAC: Dynamic Remastering: Dynamic_remastering_RAC_orainternals
14. Query transformation internals Part I query_transformation_part_1_orainternals
15. Resolving gc buffer busy wait issues gc buffer busy waits_orainternals
16. An interesting issue with hash group by feature hash_group_by_orainternals
17. RAC, voting disks, and internals orainternals_voting_disks_internals
18. Tuning CBC latch contention cardinality_feedback_to_resolv_cache_buffers_chains_latch_contention
19. Huge Pages and High CPU usage high_cpu_usage_hugepages
20. High CPU usage in kernel mode high_cpu_usage_shmdt
21. Tuning CBC latch contention tuning-latch-contention_cbc1
22. Tuning log file sync waits tuning_log_file_sync_waits
23. Oracle Log sequence oracle_log_sequence