18c Available On Premises. What’s The Next Step?
July 25, 2018Summer is on. Some of you might be on vacation, some of you might be working. DBAParadise took some time… Continue Reading
Tag: Oracle
Which Histogram Will Oracle Pick?
June 13, 2018Have you ever wondered how does Oracle determine what type of histograms to create? As of 12c there are 4… Continue Reading
Intro To Histograms. Three Basic Questions Answered.
June 6, 2018As a DBA, one day or another you will come across histograms. Either you will need to implement/delete/gather histograms to… Continue Reading
3 Things To Consider When Patching Your Database
May 16, 2018In a perfect world, DBAs would patch their databases regularly, and what I mean by that is every quarter, every… Continue Reading
All A DBA Needs To Know About Granules
May 2, 2018Remember the time when you attended your first Oracle Administration course? Remember the lesson that talked about granules and what… Continue Reading
Display Any Execution Plan With Ease
April 11, 2018Ever wondered how to display the execution plan of a SQL Statement quickly? Are you dreading the question “What is… Continue Reading
Intro To Execution Plans
April 4, 2018When there is a performance problem in the database, what is the most important thing that you need to know?… Continue Reading
What Should You Do With SQL Plan Directive Changes in 12.1?
March 14, 2018Last week we looked at SQL Plan Directives, what they are, when do they get created, how they are used… Continue Reading
What Are SQL Plan Directives?
March 7, 2018If you ever looked at an execution plan in Oracle 12c, most likely you noticed the following line, at the… Continue Reading
Declutter Your Database The Right Way
February 7, 2018I don’t like clutter, whether it is in my home or database. So when a project manager (PM) came to… Continue Reading