What Should You Do With SQL Plan Directive Changes in 12.1?
March 14, 2018Last week we looked at SQL Plan Directives, what they are, when do they get created, how they are used… Continue Reading
The place where DBAs grow
Last week we looked at SQL Plan Directives, what they are, when do they get created, how they are used… Continue Reading
If you ever looked at an execution plan in Oracle 12c, most likely you noticed the following line, at the… Continue Reading
Have you ever checked the value of the SCN number – System Change Number in your databases? Were you surprised… Continue Reading
I have covered lots of topics on Oracle Optimizer Statistics. I’d like to summarize everything you learned, or reviewed in… Continue Reading
You keep hearing that statistics are important for the Oracle database. You keep hearing that you should collect statistics. A… Continue Reading
What happens when things change and all of a sudden don’t work the same as they used to? Do you… Continue Reading
Previous post I introduced you to Selectivity and Cardinality, and asked a question at the end. Thanks to all the… Continue Reading
Most DBAs have heard of the Central Oracle Inventory, even if they don’t know details about it. But, have you… Continue Reading
You understand what the Fast Recovery Area aka FRA is, what files are stored there and how to enable it.… Continue Reading
Is it Flash Recovery Area or Fast Recovery Area? Well, you are not wrong calling it either or, but better… Continue Reading