Writing
Python/cx_Oracle utility functions
March 31, 2008
I recently created some utility functions to startup, mount and stop Oracle via cx_Oracle and thought I would share t...
Primary Keys for Slony-I
March 23, 2008
One of the prerequisites for Slony replication is to be sure that primary keys (or at least suitable columns) are def...
Memory sizing for PostgreSQL
March 11, 2008
I needed to make an assessments of a linux server’s memory footprint consumed by postgresql, however, calculating the...
Python and cx_oracle
March 9, 2008
I decided to start futzing with Python and Oracle. I generally use perl for most everything, and sometimes php for we...
now on WordPress
March 9, 2008
I just updated the blog to WordPress in order to get a few (ok, a lot) more features, and use the general editing env...
Backing up Oracle optimizer statistics
March 9, 2008
Oracle 10g has some neat features for keeping track of old statistics. Pre-10g It used to be important to backup your...
Performance Tuning: Be Proactive
June 9, 2006
I see many articles out there talking about performance tuning using the Oracle waits interface. While I am not conte...
The benefits of testing
May 9, 2006
I was recently involved on a problem for a critical production database that had slow response time for inserts. The ...