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

Home -> Community -> Usenet -> comp.databases.theory -> Re: Theoretical Basis for SELECT FOR UPDATE

Re: Theoretical Basis for SELECT FOR UPDATE

From: vc <boston103_at_hotmail.com>
Date: 30 Sep 2005 20:01:46 -0700
Message-ID: <1128133443.427135.326210@g47g2000cwa.googlegroups.com>

vc wrote:
> David Cressey wrote:
> [...]
> > By SELECT FOR UPDATE, you take out the higher level lock earlier. This
> > reduces concurrency, but also reduces deadlocks.
> >
>
> SELECT FOR UPDATE is not useful for locking databases and is not
> implemented there.

I do not like the wording. It should be:

SELECT FOR UPDATE is not needed for databases with a locking concurrency scheduler (SQL Sever, etc) and consequently not implemented there.

vc Received on Fri Sep 30 2005 - 22:01:46 CDT

Original text of this message

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