How To Drop Database Links In Another Schema
August 22, 2018You know that you cannot drop a database link in a different schema, by prefixing the database link with the… Continue Reading
Category: Oracle
18c Up And Running In 30 Minutes
August 8, 2018The fact that 18c is available on prem is old news already. You might have thought to install 18c and… Continue Reading
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
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
What Is Index Clustering Factor?
May 30, 2018Have you heard other DBAs talking about the clustering factor of an index, and saying that if the clustering factor… 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
Wonder-time For DBAs
April 25, 2018I always loved to go to school since I can remember, whether it was elementary, mid or high school, university,… 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