Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Stateless clients and locking schemes (or rather isolation levels)
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 LabReceived on Wed Jul 27 2005 - 23:51:10 CDT