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

Home -> Community -> Usenet -> c.d.o.server -> Re: Stateless clients and locking schemes (or rather isolation levels)

Re: Stateless clients and locking schemes (or rather isolation levels)

From: Serge Rielau <srielau_at_ca.ibm.com>
Date: Thu, 28 Jul 2005 00:51:10 -0400
Message-ID: <3kr6i3FusrefU1@individual.net>


pobox002_at_bebub.com wrote:
> What I was trying to get across was that it appears to me that
> copying data to a private area in a session, usually a temporary
> table, is a technique that can be employed in a locking database
> by an application to provide a read consistent view of the data
> when needed. I think this adds complexity to the application and
> not having to do it because the database does it for me is a real
> benefit. The fact that I imagine this would be more complex when
> state is not maintained was an aside that in retrospect was not
> necessary and in fact detracted from the point I was trying to
> make.

Undeserved credit to temp tables, actually.... Either way, glad we straightened that one out. I've heard too many misconceptions about "optimistic locking" vs read consistency of late and was starting to wonder whether I'm the one having it wrong. :-)

Cheers
Serge

-- 
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Received on Wed Jul 27 2005 - 23:51:10 CDT

Original text of this message

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