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
The place where DBAs grow
You know that you cannot drop a database link in a different schema, by prefixing the database link with the… Continue Reading
The fact that 18c is available on prem is old news already. You might have thought to install 18c and… Continue Reading
Summer is on. Some of you might be on vacation, some of you might be working. DBAParadise took some time… Continue Reading
Have you ever wondered how does Oracle determine what type of histograms to create? As of 12c there are 4… Continue Reading
As a DBA, one day or another you will come across histograms. Either you will need to implement/delete/gather histograms to… Continue Reading
In a perfect world, DBAs would patch their databases regularly, and what I mean by that is every quarter, every… Continue Reading
Remember the time when you attended your first Oracle Administration course? Remember the lesson that talked about granules and what… Continue Reading
Ever wondered how to display the execution plan of a SQL Statement quickly? Are you dreading the question “What is… Continue Reading
When there is a performance problem in the database, what is the most important thing that you need to know?… Continue Reading
Last week we looked at SQL Plan Directives, what they are, when do they get created, how they are used… Continue Reading