More Papers By Tim Gorman and Jeff Maresh

One or two of you might be wondering how I've managed to find the time to write so many articles recently, and the answer to this is down to something you might have read about a few weeks ago where our local train service is trialling wireless broadband internet access on the Brighton to London train each morning. I've been travelling up quite a bit recently and if you get there early (it's only on the first three carriages) you can connect up for free for the hour's journey. Rather than just sit looking out of the window it's been a chance to catch up with email and do a bit of product evaluation. The fact the wireless connection actually works is a bit of a surprise given the fact that the trains often themselves don't work, but whilst it's free it's a pretty good service and makes the hour's journey go quite quickly.

Anyway, I've been meaning to post a link to this site for a while. The other week I mentioned an article by Jeff Maresh on Supercharging Star Transformations and I also bookmarked at the time the author's other paper on Materialized Views In Action. If you take a look though at the site that Jeff's papers are hosted on though, the Evergreen Database Technologies Downloadable Library, there's a whole host of papers and presentations that would be of interest to DBAs and DW developers, including ones by Tim Gorman on Partitioning in Oracle Data Warehouses and Tuning PL/SQL using the DBMS_PROFILER, Oracle 9i Table Compression and Optimizing Parallel Query in Oracle 8i (recommended by Doug Burns in his Tuning Parallel Execution paper) and others by Jeff Maresh on Tuning Sort and Hash Memory Areas, SQL*Loader Strategies for DW Implementations and Understanding Locking in Oracle. All good stuff and well worth a read (especially if you're going to up London on the train).