Use 11g features for a 9i to 10g upgrade!

It's 10:50PM, and you know that all us night owls are coming to life.

I just finished reviewing the Oracle white papers on Real Application Testing for 9i and 10g databases this is great technology. If you are looking to migrate your existing systems to 11g and Real Application Testing is in the budget, this is a great value proposition to sweeten the deal.

Here's the scoop: If you have an existing 11g database installation, you can use "opatch" to retrofit the workload capture functionality of the 11g Real Application Testing to an existing 9i or 10g database. After the patch is applied and the capture process enabled, it is a simple process to "replay" those transactions inside the 11g environment.

Oracle put together a great white paper (all 48 pages) on how this technology can be applied to an 9i to 10g migration. It looks like all us procrastinators who dreaded the regression testing in our future just got a lifeline.