DBMS_ERRLOG and LOG ERRORS – How It Can Help You
Published: Thu, 05/16/19
The other day I had to load thousands of rows of data, from an e ternal table. During the load the data was also transformed by a function. I was…
Diana Robete
database advise, step by step guides, how to emails
What Is The Log Buffer And Why Is It Important?
Published: Fri, 05/10/19
It’s been a while since you’ve taken an Oracle course, and especially the one where you learned about the basics, the fundamentals. Maybe some of the…
The Best Two Things You Can Do When Planning An Outage
Published: Thu, 05/02/19
Outages of data centers are no fun, whether they are planned or unplanned. Many teams and people are involved when an outage occurs. The bigger the…
Database Refresh Part 3 – RMAN
Published: Thu, 04/25/19
This is the final part of the Database Refresh series, and you guessed it, it is about database refresh using RMAN duplicate methodology. Just as we…
Database Refresh Part 2 – Datapump
Published: Thu, 04/18/19
Last week’s post was about automating the database refresh process. I recommended you to document every detail you follow, when refreshing one of your…
Database Refresh Part 1 – What Method To Use?
Published: Thu, 04/11/19
Refreshing databases is part of the DBA’s job. Since this is a repetitive task (you e ecute it many times, again and again), the best approach is to…
What Is Average Active Session aka AAS?
Published: Mon, 03/18/19
Are you familiar with AAS aka Average Active Session Metric? If not, don’t worry you are not the only one. There are lots of good articles and slides…
7 Steps To Setup Privilege Analysis
Published: Wed, 02/27/19
Last week I showed you how Privilege Analysis can help you sort out and standardize security in your database. Today, I’ll show you how to setup…
What Is Privilege Analysis?
Published: Thu, 02/14/19
I like order, I like patterns, I like consistency in general, but especially in the databases I manage. Most of the databases I manage, were not…
Wonder Time For DBAs – What Are The Results?
Published: Thu, 02/07/19
Last year, I introduced you to the idea of Wonder Time For DBAs. I have not come up with the Wonder Time idea, instead it was introduced to me by no-…