What Is The Relationship Between SCNs and DB Links?
January 24, 2018Have you ever checked the value of the SCN number – System Change Number in your databases? Were you surprised… Continue Reading
Tag: Oracle
3 Things You Wish You’ve Learned In School About Oracle’s SCN
January 17, 2018There are things you don’t learn in school. There are things you hear about in school, that are not explored… Continue Reading
So You Think You Can Gather Stats?
December 6, 2017I have covered lots of topics on Oracle Optimizer Statistics. I’d like to summarize everything you learned, or reviewed in… Continue Reading
4 Things To Know About Statistics History
November 22, 2017By default, whenever new statistics are gathered in the database, the existing statistics are backed up in the data dictionary.… Continue Reading
3 Things You Must Know About Oracle Optimizer Statistics
October 25, 2017You keep hearing that statistics are important for the Oracle database. You keep hearing that you should collect statistics. A… Continue Reading
How To Connect To 12c Databases
October 11, 2017Do you find yourself searching on Google for ways to connect to 12c database, especially PDBs? Do you feel frustrated,… Continue Reading
How To Make login.sql Work Again In 12.2 and 11.2.0.4
August 30, 2017What happens when things change and all of a sudden don’t work the same as they used to? Do you… Continue Reading
Strong vs Weak Selectivity – Everything A DBA Needs To Know
August 23, 2017Previous post I introduced you to Selectivity and Cardinality, and asked a question at the end. Thanks to all the… Continue Reading
OUI and OPatch What Are They Used For?
August 3, 2017The last two weeks I’ve been talking about the Central Oracle Inventory and the Local Oracle Inventory. I have mentioned… Continue Reading
All You Need To Know About The Local Oracle Inventory
July 26, 2017Most DBAs have heard of the Central Oracle Inventory, even if they don’t know details about it. But, have you… Continue Reading