I got a chance to discuss some of the issues we have been facing in this area with the CBO team at Oracle OpenWorld last week, and learned about some of the changes they have planned for the future. Please don’t take this as fact, this is only based on my recollection of from an …
After we migrated one of our instances from Oracle 11.2.0.4 to 12.1.0.2 we ran into some serious latch contention that basically took down the instance. From online research, and discussion with other DBAs I don’t think we are the only customer that has run into this problem, so I wanted to share my investigation and …
Adaptive Dynamic Sampling and the Result Cache: RC Latch Read More »
During migration testing to Oracle 12, one of our teams complained about regression of a particular query. Drilling into what was going on identified some a problem with Adaptive Dynamic Sampling, and certainly not the first one we have encountered. I will detail the steps to reproduce, and my understanding of what is going on. …
Incorrect Cardinality Adjustment caused by Dynamic Statistics Read More »