What Are SQL Plan Directives?
March 7, 2018If you ever looked at an execution plan in Oracle 12c, most likely you noticed the following line, at the… Continue Reading
The place where DBAs grow
If you ever looked at an execution plan in Oracle 12c, most likely you noticed the following line, at the… Continue Reading
I don’t like clutter, whether it is in my home or database. So when a project manager (PM) came to… Continue Reading
Have you ever checked the value of the SCN number – System Change Number in your databases? Were you surprised… Continue Reading
There are things you don’t learn in school. There are things you hear about in school, that are not explored… 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
By default, whenever new statistics are gathered in the database, the existing statistics are backed up in the data dictionary.… Continue Reading
You keep hearing that statistics are important for the Oracle database. You keep hearing that you should collect statistics. A… Continue Reading
Do you find yourself searching on Google for ways to connect to 12c database, especially PDBs? Do you feel frustrated,… 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