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

Home -> Community -> Usenet -> c.d.o.server -> Re: Select for Update in multithreaded application

Re: Select for Update in multithreaded application

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 31 Jul 2006 11:02:39 -0700
Message-ID: <1154368959.795444@bubbleator.drizzle.com>


Nick Selwyn wrote:

> We now need to be able to run multiple instances of the application
> simultaneously, and therefore need a mechanism that allows locking of
> rows between the different processes to prevent overlapping reads
> between the different instances.

Why? What is the business case?

My initial thought is that the cure will be worse than the disease.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Mon Jul 31 2006 - 13:02:39 CDT

Original text of this message

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