MySQL Memory Usage Profile Script
There are various tools available for gathering and monitoring mysql performance data, but it’s not...
Pythian Blog: Data Analytics, Cloud Computing, and Database Management (166)
Aligning ASM Disks on Linux
Linux is a wonderful operating system. However there are a number of things that one needs to do to...
The Dirty Dozen #1: Lack of Communication
As promised, here is the first part of the series based on the MARSS posters — The Dirty Dozen —...
RMAN Recipes: How to Switch Oracle Logs Automatically
So you have swallowed the standby bait. You have used RMAN duplicate to create a sparkling new...
DBMS_SCHEDULER and Implicit Commits
As usual, Oracle introduces new features, and we read the documentation about how they work and we...
Exploiting SYSDBA Invoker Rights Using Trigger on Database
This is a follow up on my previous post about SYSDBA keeping invoker rights when calling PL/SQL...
RMAN reports, or What Is the ETA of My Backup?
Over-the-Top Tales from the Trenches. Motto: Bringing order to the chaos of every day DBA life....
No data found -> success in dbms_scheduler
One of our clients found a bug with dbms_scheduler: it logs a job as successful when a ORA-01403 is...
Sequences in Oracle 10g RAC
Just recently I got a call from a developer. He had a table with a primary key populated by a...
MySQL GROUP BY and DISTINCT Oddity
At the end of my last MySQL post I mentioned strange behavior with GROUP BY and DISTINCT. In Oracle...
