Re: How to avoid waiting for locks during delete

From: Ed prochak <ed.prochak_at_magicinterface.com>
Date: 11 Aug 2003 11:19:31 -0700
Message-ID: <4b5394b2.0308111019.213aeadb@posting.google.com>

"André Hartmann" <andrehartmann_at_hotmail.com> wrote in message news:<3f33c687$1_at_olaf.komtel.net>...
> Hmmmmm,

[]
>
> really, no other possibility ? That would be VERY disappointing and smash
> my whole picture of Oracle being so sophisticated when it comes to locking
> mechanisms.... :(
>
> AH
> :(

But have you seen this kind of condition in real life on ORACLE? Have you seen this in in other DBMSs with less sophisticated architecture? (Not a pretty sight.)

If this condition does arise, there is no alternative to waiting no matter what your locking model. (Just consider task 1 doing an UPDATE on a record in table B as task 2 does a delete on the parent record in table A. Someone has to wait or get an error.

You are worrying about the wrong issues, IMHO.

ed Received on Mon Aug 11 2003 - 13:19:31 CDT