Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: what's a "reasonable" length of time to keep a cursor open?
mh_at_pixar.com wrote:
> DA Morgan <damorgan_at_psoug.org> wrote:
>> And your Oracle version is? >> >> Load the records into a global temporary table if they are >> available in your version.
>> But I've got a problem with any process that takes several days to >> complete. It might be worth investing your efforts into tuning the >> offending process.
<snip>
Knowing this, I would highly recommend looking into Oracle's Advanced Queueing.
http://download.oracle.com/docs/cd/B19306_01/server.102/b14257/toc.htm
It sounds like what you are trying to build is already present in the Oracle database. Rather than reinvent the wheel, try to leverage the tool you paid for.
HTH,
Brian
-- =================================================================== Brian Peasland dba_at_nospam.peasland.net http://www.peasland.net Remove the "nospam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three" - Unknown -- Posted via a free Usenet account from http://www.teranews.comReceived on Tue Aug 28 2007 - 12:59:04 CDT