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
2 Useful Things To Know About SQL Plan Baselines
September 27, 2017Last two weeks, we covered the building blocks of SQL Plan Management, and then we got started with SQL Plan… Continue Reading
One Easy Step To Get Started With SQL Plan Baselines
September 20, 2017If you wonder how SQL Plan Baselines work, then this post is for you! If you want to get started… Continue Reading
Building Blocks Of SQL Plan Management 12c
September 14, 2017Ever found yourself in a situation when you had to pretend you understand and know everything that is going on… 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
5 Things To Better Understand Selectivity And Cardinality
August 9, 2017If you really want to confuse a candidate for a DBA job interview, just ask the question: “Can you explain… 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