NOTE: This post originally appeared on The Pythian Group blog on 6 June 2008, and is reposted here with permission.A little over a week ago, a teammate and I were trying to use Oracle’s FLASHBACK TABLE to undo an “oops” UPDATE statement that a client’s developers had run on one... [Read More]

Moving On Up

Today is my last day at my current employer. It has been an incredible learning experience, and I'll be forever grateful to the man who gave me the opportunity almost 7 years ago having zero knowledge of either Oracle or database administration.I have accepted an offer from noted consulting firm... [Read More]

Helpful Hints for RMAN Recovery

When you copy your backup files onto disk for RMAN to use for practicing cold-metal restore/recovery, make sure that they are at least visible to the oracle OS user.  It doesn't help to have them owned by root with perm 640.Thank me later.

Bind Variables and Parallel Queries Do Not Mix

This post was promised long ago, and I apologize for the tardiness. Some of you may recall my whining about seemingly unexplainable instance hanging since migrating our database to 64-bit hardware in September. Well, after some back and forth and hand-offs from one rep to another, we finally were given... [Read More]

Don: 1 vs. 1Z0-043: 0

Passed the 1Z0-043 exam today, otherwise known as the OCP exam. Just need some other jazz like my hands-on course requirement form to be processed and then I should get my badge and gun and key to the executive washroom.Thanks to Bradd Piontek for reminding me of how silly it... [Read More]