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
The place where DBAs grow
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
Have you heard other DBAs talking about the clustering factor of an index, and saying that if the clustering factor… 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
If you ever looked at an execution plan in Oracle 12c, most likely you noticed the following line, at the… Continue Reading
Have you ever had to determine the SQL ID of the query you just ran? I am not talking about… Continue Reading
I don’t like clutter, whether it is in my home or database. So when a project manager (PM) came to… Continue Reading