What Is The Relationship Between SCNs and DB Links?
Published: Thu, 01/25/18
Have you ever checked the value of the SCN number – System Change Number in your databases?Were you surprised to find out that some databases had very…
Diana Robete
database advise, step by step guides, how to emails
3 Things You Wish You’ve Learned In School About Oracle’s SCN
Published: Thu, 01/18/18
There are things you don’t learn in school.There are things you hear about in school, that are not e plored in-depth.There are things you learn in…
What Skills Are You Going To Master in 2018?
Published: Thu, 01/11/18
We are two weeks into 2018. Most likely you are back to work, in full force, ready to fight the new fires!Are you ready for an AWESOME year, full of…
So You Think You Can Gather Stats?
Published: Thu, 12/07/17
I have covered lots of topics on Oracle Optimizer Statistics. I’d like to summarize everything you learned, or reviewed in the past month with me.I…
How To Compare Current Stats With Stats From History?
Published: Thu, 11/30/17
Imagine this. You get a call. A specific SQL statement is running slow today, and the statement was running fine yesterday.You quickly review the SQL…
4 Things To Know About Statistics History
Published: Thu, 11/23/17
By default, whenever new statistics are gathered in the database, the e isting statistics are backed up in the data dictionary.The statistics backups…
What Type Of Stats To Gather (Bonus Script)
Published: Thu, 11/16/17
How do you gather statistics in your database?Do you gather statistics randomly when you remember, or do you gather statistics when there is a…
How Are Statistics Gathered In The Database?
Published: Thu, 11/09/17
I am very e cited and honored! You know why? Because I got the opportunity to write not only for you, my audience, but also for IOUG's blog, and my…
3 Things You Must Know About Oracle Optimizer Statistics
Published: Thu, 10/26/17
You keep hearing that statistics are important for the Oracle database.You keep hearing that you should collect statistics.A DBA tells you that you…
How To Connect To 12c Databases
Published: Thu, 10/12/17
Do you find yourself searching on Google for ways to connect to 12c database, especially PDBs?Do you feel frustrated, that you keep forgetting the…