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
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
Is The Latest Bundle Patch for 12.1.0.2 Fixing SQL Plan Directive’s Behavior?
March 28, 2018Take a guess, you have 50% chances of being right! I was very excited last week, as I got to… 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
How To Find The SQL ID Of The Statement You Just Ran?
February 21, 2018Have you ever had to determine the SQL ID of the query you just ran? I am not talking about… 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
What Is The Relationship Between SCNs and DB Links?
January 24, 2018Have you ever checked the value of the SCN number – System Change Number in your databases? Were you surprised… Continue Reading
3 Things You Wish You’ve Learned In School About Oracle’s SCN
January 17, 2018There are things you don’t learn in school. There are things you hear about in school, that are not explored… Continue Reading