Understanding Why ORA-04021 TIMEOUT OCCURRED WHILE WAITING TO LOCK OBJECT Happens
June 6, 2019One of my readers asked me if I could write about locking and blocking in the database, more specifically about… Continue Reading
Tag: Oracle
Step By Step Example Of Working With DBMS_ERRLOG
May 22, 2019Last week I showed you a cool tool available since 10.2.0.1, that not every DBA is aware of. I was… Continue Reading
DBMS_ERRLOG and LOG ERRORS – How It Can Help You
May 15, 2019The other day I had to load thousands of rows of data, from an external table. During the load the… Continue Reading
The Best Two Things You Can Do When Planning An Outage
May 1, 2019Outages of data centers are no fun, whether they are planned or unplanned. Many teams and people are involved when… Continue Reading
Database Refresh Part 3 – RMAN
April 24, 2019This is the final part of the Database Refresh series, and you guessed it, it is about database refresh using… Continue Reading
Database Refresh Part 2 – Datapump
April 18, 2019Last week’s post was about automating the database refresh process. I recommended you to document every detail you follow, when… 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
What Is Average Active Session aka AAS?
March 17, 2019Are you familiar with AAS aka Average Active Session Metric? If not, don’t worry you are not the only one.There… 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
What Is Privilege Analysis?
February 13, 2019I like order, I like patterns, I like consistency in general, but especially in the databases I manage. Most of… Continue Reading