23c New Feature – Alias in the GROUP BY Clause?
January 31, 2024You read that right! One of the best features of Oracle 23c is the use of aliases in the GROUP… Continue Reading
Category: Uncategorized
How To Fix ORA-31600 During Import Datapump
June 12, 2019One day I was trying to run an import datapump job, and it kept failing. The error was pointing to… Continue Reading
What Is The Log Buffer And Why Is It Important?
May 9, 2019It’s been a while since you’ve taken an Oracle course, and especially the one where you learned about the basics,… Continue Reading
Database Refresh Part 1 – What Method To Use?
April 10, 2019Refreshing databases is part of the DBA’s job. Since this is a repetitive task (you execute it many times, again… Continue Reading
7 Steps To Setup Privilege Analysis
February 26, 2019Last week I showed you how Privilege Analysis can help you sort out and standardize security in your database. Today,… 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
How To Maintain The Fast Recovery Area
July 12, 2017You understand what the Fast Recovery Area aka FRA is, what files are stored there and how to enable it.… Continue Reading
3 Questions Answered About FRA – What, Who, How?
June 28, 2017Is it Flash Recovery Area or Fast Recovery Area? Well, you are not wrong calling it either or, but better… Continue Reading
To Drop Or Not To Drop A Column – Find Out The Answer
June 22, 2017Don’t you love it when people come to you for advice? I sure do! I got a call the other… Continue Reading
DBA Documentation-3 Most Common Questions Answered: Why,Where,What
June 7, 2017Last week’s post got tremendous response! If you missed it, you can check it out here! Thank you to all… Continue Reading