Re: row vs row.column level locking

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Thu, 15 Dec 2005 23:09:28 GMT
Message-ID: <43a1f5c1.199153640@localhost>

On Thu, 15 Dec 2005 23:33:19 +0100, Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote:

>On Thu, 15 Dec 2005 19:03:20 GMT, netcomradeNSPAM_at_bookexchange.net
>(NetComrade) wrote:
>
>>Does anyone know if there are any plans for column level locking?
>>
>>I feel different processes should be able to update different columns
>>w/o blocking each other, as long as what's updated is not the PK.

>So you want to get rid of read consistency?
>

Maybe I am not thinking it through properly. Read consistency can still exist. Oracle guarantees that the set of data seen by a statement is consistent with respect to a single point in time and does not change during statement execution. In order to achieve that on column level RDBMS will need to track more changes on a sub-row level (e.g. the way UNDO and oracle blocks are architected might have to change).
.......
We run Oracle 9.2.0.6 on RH4 AMD
remove NSPAM to email Received on Thu Dec 15 2005 - 17:09:28 CST