Map Reduce is a computer technology algorithm that is built on the age old concept of functional programming. The goals of functional programming can be simplistically described as: every program returns a value “map” lists of values to functions Map…
Month: April 2011
MySQL mysqlbinlog vs. Oracle logmnr
MySQL provides the mysqlbinlog utility to parse binary transaction logs for any number of purposes which may include replication, auditing, or troubleshooting. Oracle also provides this functionality through a PL/SQL package called dbms_logmnr, more commonly referred to as “Log Miner”.…
Accessing ASM via FTP
This is a documented feature, but I wanted to post my notes so I could reference them if needed. All you basically have to do to set this up is: install XML DB (package dbms_xdb). This is installed if you…
Automatically switching connections over with Dataguard and zero code changes
In 10.2.0.4, I tested the ability of off the shelf code to automatically connect to a database that has been “switched over to”. A switchover is a graceful exchange of database responsibilities that prevents a split brain scenario where two…
Format output of crsctl status for RAC 11gR2 (and now 12c)
crs_stat -t in 10g was great because you could just print it out and grep for OFFLINE or UNKNOWN to determine if there was a problem. 11g deprecated the use of crs_stat -t. It’s not just that you shouldn’t use…