Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: what's a "reasonable" length of time to keep a cursor open?

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

From: <sybrandb_at_hccnet.nl>
Date: Thu, 23 Aug 2007 07:29:27 +0200
Message-ID: <8m6qc3pofmipdk6s263h4t6q1dkmp1behi@4ax.com>


On Wed, 22 Aug 2007 23:55:13 GMT, mh_at_pixar.com wrote:

>What's a "reasonable" length of time to keep a cursor open?
>I'm not looking for a hard and fast number, just a general
>concensus.

The general consensus here is 'applications' like this should be dumped and rewritten. Or get mended by throwing more iron at the problem.
Surely those teraflops involved in generating moving rats can find more useful employment elsewhere.

-- 
Sybrand Bakker
Senior Oracle DBA
Received on Thu Aug 23 2007 - 00:29:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US