Archive for April, 2011

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 Reduce uses pieces of this methodology, defined as the following: Map – This function... »

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”. MySQL is very convenient in that all you need to enter at the command... »

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 create a database with DBCA by default. Set the ftp port used by XML... »

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 databases are taking traffic at the same time. In a switchover, dataguard guarantees, by... »

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 it because it will be removed in a future release, it also will print... »