Re: Oracle Select/Insert Locking

From: Ed prochak <ed.prochak_at_magicinterface.com>
Date: 13 Feb 2004 11:29:48 -0800
Message-ID: <4b5394b2.0402131129.3a3f68e4@posting.google.com>

Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1076533565.155270_at_yasure>...
> Bricklen wrote:
>
> > "A race condition is an undesirable situation that occurs when a device
> > or system attempts to perform two or more operations at the same time,
> > but because of the nature of the device or system, the operations must
> > be done in the proper sequence in order to be done correctly."
> >
> > http://searchstorage.techtarget.com/sDefinition/0,,sid5_gci871100,00.html
>
> Thanks. Still looks like nothing more than bad design.

Daniel,
I think the OP is working for one of those managers that likes his developers to violate the laws of physics on a regular basis.

Bricklen,
Why Daniel thinks this is bad design is partly because you never stated your business need. Your design might not answer the real need, another design may be better. If you really want that insert to work, you will have to create and use a monitor process (ie, force this to be a single threaded transaction). That would work but be a performance nightmare.

hth,
ed Received on Fri Feb 13 2004 - 13:29:48 CST