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
Category: Database
What Skills Are You Going To Master in 2018?
January 10, 2018We are two weeks into 2018. Most likely you are back to work, in full force, ready to fight the… 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
How To Compare Current Stats With Stats From History?
November 29, 2017Imagine this. You get a call. A specific SQL statement is running slow today, and the statement was running fine… 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
What Type Of Stats To Gather (Bonus Script)
November 15, 2017How do you gather statistics in your database? Do you gather statistics randomly when you remember, or do you gather… Continue Reading
How Are Statistics Gathered In The Database?
November 8, 2017Do you gather statistics regularly for your databases? Do you gather statistics explicitly, with your own script, or do you… 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 Use LISTAGG To Create Awesome DBA Reports
October 4, 2017Do you want to write some kick ass reports? Convert some rows into lines very quickly and easily? or Do… Continue Reading