Aug 242010

Recently a colleague sent me a quick instant message asking if I knew of any way in Oracle to make a query run long enough to test a “cancel query” function he was writing in Java.  He had tried several queries that usually produced the results he was looking for, however there wasn’t enough data in his test environment to reproduce the wait time he needed.  I thought about it for a minute and then proposed the following solution.

Oracle provides the DBMS_LOCK package which allows users to manage their own locks.  One handy subprogram in this package in the SLEEP method, which suspends the current session for the specified number of seconds.  I have used DBMS_LOCK.SLEEP a number of times in the past so I knew this would do the trick. Continue reading »

Nov 112009

I thought I would post a whitepaper I wrote earlier this year under the auspices of my employer, M. Miller & Associates.  This whitepaper is basically a summary of things I have observed over the course of my career in IT, particularly in regard to database design.  I can assure you that I eat my own dog food when it comes to the things I discuss.  I’m in the trenches every day putting into practice these concepts in order to produce solid, forward thinking designs.  We’ll eventually post this on the company website, but until then I make it available here in hopes it provokes thought and discussion.  Let me know what you think.

OLAP Fiendly OLTP Design – Planning Ahead for the Inevitable Data Warehouse

Sep 112009

My current development environment has to be the best configuration I’ve had to date in my development career.  Here are some of the specifics:

  • HP EliteBook laptop (8730w)
  • 2.4GHz Core 2 Duo 64-bit
  • 6GB Memory
  • openSuse 11.1 64-bit

The move to Linux from Windows has been a huge plus, though not without its own challenges.  But it’s not just the hardware and OS.  Here are the tools that round out a highly productive development environment: Continue reading »