MSDB – Cleanup is necessary
Recently I have been asked to work on the task which is to reduce the size of a MSDB database. The...
Recently I have been asked to work on the task which is to reduce the size of a MSDB database. The...
A Baffling Case of ORA-00942 Recently we had a good reason to find out what was going on behind the...
The other day we had a situation with an OEM 12cR2. We performed maintenance in a 2-node cluster...
Over the past 8 months, I have had the pleasure of working on a soon-to-be-released update for our...
I’m sure one of the most popular scripts for Apps DBAs on My Oracle Support is cmclean.sql from MOS...
My friend Øyvind Isene suggested that I store a DUPLICATE RMAN script that works in a safe place in...
One of the biggest selling features of Oracle's flagship engineered system - Exadata - is the...
At Pythian's internal forum, someone just asked the following question: "The team here is...
JDK is the environment to develop Java programs, and updating Java on Linux boxes is a requirement...
This week, my DBA team fulfilled a request to restore 1 month old lost data. A review of the RMAN...