Re: Changing isolation level?

Hemant Shah wrote:

> While stranded on information super highway mcstock wrote:
> :)refer to the SET TRANSACTION statement in the SQL Reference manual
> :)
> :)relevant options are: ISOLATION LEVEL SERIALIZABLE and ISOLATION LEVEL READ
> :)COMMITTED (default)
> :)
> :)doesn't look like ISOLATION LEVEL SERIALIZABLE does what you want
> :)
> :)
> :)you'll also want to carefully review the sections on Data Concurrency and
> :)Consistency in the Concepts manual
> :)
>
>
> As others have mentioned, none of the isolation level will block readers.
> I will have to find some other way.

Why? Oracle has had this model for more than a decade and it has never caused anyone a problem. Which, I would think, would make you consider that maybe the problem is in your design requirement.

Why not avoid the wasted effort creating a performance and scalability killing kludge and just present the business problem you are trying to solve?

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)