Re: Phantom Inserts

In article <3iil6n$cnu@jac.zko.dec.com>, smithi@nova.enet.dec.com (Ian Smith) writes... . . . > >I expect that index locks will prevent the T1 transaction from doing the insert >(i.e. a lock wait) until the T0 transaction commits. Just to clarify the leaf level index nodes are implemented as records in Oracle Rdb. In this case the node will be locked in a read mode so everyone can access the data [index key|DBkey pair] in the record. An insert will have to acquire an exclusive lock to insert into this value range. ********************************************************************* *** Jay Feenan *** *** Oracle Rdb Engineering *** *** *** *** opinions expressed here are solely my own and not those of my *** *** employer. *** *** *** *********************************************************************