Re: what's a "reasonable" length of time to keep a cursor open?

From: <sybrandb_at_hccnet.nl>
Date: Tue, 28 Aug 2007 23:59:47 +0200
Message-ID: <4i69d3tto07uhkg0atlv7tk4plt673tun7@4ax.com>

On Tue, 28 Aug 2007 12:59:04 -0500, Brian Peasland <dba_at_nospam.peasland.net> wrote:

>Rather than reinvent the wheel, try to leverage the
>tool you paid for.

I would like to endorse that comment. Currently you are setting up a tool that should run on a low level as possible in a high level environment.
In 1987 I took over an application which was driven by a homegrown record locking system, and a homegrown index sequential system. The system was written in Vax-Pascal instead of Assembler, it was a complete failure.

-- 
Sybrand Bakker
Senior Oracle DBA

Received on Tue Aug 28 2007 - 16:59:47 CDT