3 Things To Consider When Patching Your Database
Published: Thu, 05/17/18
In a perfect world, DBAs would patch their databases regularly, and what I mean by that is every quarter, every time the quarterly patches come…
Diana Robete
database advise, step by step guides, how to emails
All A DBA Needs To Know About Granules
Published: Thu, 05/03/18
Remember the time when you attended your first Oracle Administration course?Remember the lesson that talked about granules and what they are?Neither…
Wonder-time For DBAs
Published: Thu, 04/26/18
I always loved to go to school since I can remember, whether it was elementary, mid or high school, university, or later on the DBA program. Even if…
Display Any Execution Plan With Ease
Published: Thu, 04/12/18
Ever wondered how to display the e ecution plan of a SQL Statement quickly?Are you dreading the question “What is the e ecution plan of this SQL?”?Are…
Intro To Execution Plans
Published: Thu, 04/05/18
When there is a performance problem in the database, what is the most important thing that you need to know?The e ecution plan of the SQL Statement…
Is The Latest Bundle Patch for 12.1.0.2 Fixing SQL Plan Directive’s Behavior?
Published: Thu, 03/29/18
Take a guess, you have 50% chances of being right!I was very e cited last week, as I got to finally deploy the January 2018 Bundle Patch to the test…
What Should You Do With SQL Plan Directive Changes in 12.1?
Published: Thu, 03/15/18
Last week we looked at SQL Plan Directives, what they are, when do they get created, how they are used and maintained. Need an intro to SQL Plan…
What Are SQL Plan Directives?
Published: Thu, 03/08/18
If you ever looked at an e ecution plan in Oracle 12c, most likely you noticed the following line, at the bottom of the e ecution plan:... Note -----…
How To Find The SQL ID Of The Statement You Just Ran?
Published: Thu, 02/22/18
Have you ever had to determine the SQL ID of the query you just ran?I am not talking about finding the SQL ID of a query run in another session, or…
Declutter Your Database The Right Way
Published: Thu, 02/08/18
I don’t like clutter, whether it is in my home or database. So when a project manager (PM) came to me and said, we have a project to cleanup some…