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
The place where DBAs grow
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
Imagine this. You get a call. A specific SQL statement is running slow today, and the statement was running fine… Continue Reading
By default, whenever new statistics are gathered in the database, the existing statistics are backed up in the data dictionary.… Continue Reading
How do you gather statistics in your database? Do you gather statistics randomly when you remember, or do you gather… Continue Reading
Do you gather statistics regularly for your databases? Do you gather statistics explicitly, with your own script, or do you… Continue Reading
You keep hearing that statistics are important for the Oracle database. You keep hearing that you should collect statistics. A… Continue Reading
Last two weeks, we covered the building blocks of SQL Plan Management, and then we got started with SQL Plan… Continue Reading