Re: Changing isolation level? ++ scenarios

> lots of good discussion, but no one has yet addressed the basic issue: no
> matter what isolation level is available, data can change immediately after
> the read

To solution is simple, yet no one has seen it. Install Personal Oracle. Or, if you are running Enterprise Edition (or Standard), set MAX_CONCURRENT_SESSIONS=1 in your INIT.ORA and bounce the instance. This way, no other user can change data immediately after someone else has read it. Problem solved.

Cheers,
Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"