The getMOSPatch V2 is here!
A while ago I created a Bash script called getMOSPatch.sh. It's purpose was to allow downloading...
Pythian Blog: Data Analytics, Cloud Computing, and Database Management | Pythian (3)
InnoDB flushing and Linux I/O
Since documentation is not very clear to me on the topic of InnoDB flushing in combination with...
Implementing fuzzy search in SQL server - part 2: Levenshtein distance
The Levenshtein Distance, as discussed in my last post, is a way to measure how far two strings are...
Oracle E-Business Suite: Virtual host names
The ability to use virtual host names with Oracle E-Business Suite is one of the features that I...
Magic of "\d" in Vertica
A quick neat way to list down important and oft-needed information like names of databases,...
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...
Oracle Database 12c Patching: DBMS_QOPATCH, OPATCH_XML_INV, and datapatch
Background Oracle Database 12c brings us many new features including: the long needed ability to...
Oracle Database: Query to List All Statistics Tables
If you were a big fan of manual database upgrade steps, perhaps you would have come across this...
Mining the AWR to Identify Performance Trends
Sometimes it's useful to check how performance of a SQL statement changes over time. The diagnostic...
Duplicate Database from Active Database — Just Works!
My friend Øyvind Isene suggested that I store a DUPLICATE RMAN script that works in a safe place in...
