CPU_COUNT Parameter And Instance Caging
October 31, 2019Have you wondered how many CPUs are allocated to your database? One of my reader has, and he asked me… Continue Reading
Tag: DBA
Fix ORA-04095: Trigger Already Exists On Another Table
September 10, 2019One of my readers asked me what is the cause of the following error, and what is the work around… Continue Reading
What To Do When The Export Fails With ORA-01466?
August 7, 2019The nightly backup job you have scheduled for your database, the datapump export job, starts failing with the following error:… Continue Reading
Oracle’s Recycle Bin: Security Considerations
July 10, 2019I planned last week’s post to be the last one on the recycle bin. And then I got a nice… Continue Reading
Oracle’s Recycle Bin – Part 2
July 3, 2019Last week we explored the purpose of the recycle bin, what goes into the recycle bin and how to bypass… Continue Reading
Working With Oracle’s Recycle Bin
June 27, 2019One of the greatest things that Oracle added to its database, in version 10g, was the recycle bin. What I… Continue Reading
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
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
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