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…
database advise, step by step guides, how to emails
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…