Mongostat - A nifty tool for Mongo DBAs
One of the main MongoDB DBA's task is to monitor the usage of MongoDB system and it's load...
Pythian Blog: Data Analytics, Cloud Computing, and Database Management (117)
RMAN 11g : How to restore / duplicate to a more recent patchset
In an Oracle DBA's life, you'll be regularly asked to work on applying a new patchset on a database...
Permissions in Redshift administration
As with any database administration strategy, management of Redshift requires setting and revoking...
Tracking ASM Metrics
Collecting ASM IO Metrics If you are an Oracle DBA, then it is quite likely that Oracle ASM is used...
Handling the Leap Second - Linux
Last week I published a blog post titled " Are You Ready For the Leap Second?", and by looking at...
Part 1: How to effectively use a performance schema
Performance Schema (PS) has been the subject of many, many recent discussions, presentations, and...
Making existing SQLPLUS Scripts 12c and Container DB (PDB) compatible
Oracle 12c introduces new catalog features including CDB_ dictionary views (which include a CON_ID...
MySQL Query profiling with Performance Schema
One of my favorite tools for query optimization is profiling. But recently I noticed this warning:...
EM12c : Login to GUI with the correct password causes authentication failure
So the other day I was trying to log in to my EM12c R4 environment with the SSA_ADMINISTRATOR user,...
fsfreeze in Linux
The fsfreeze command, is used to suspend and resume access to a file system. This allows consistent...
