Re: Drawbacks to Serializable Mode?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 26 Feb 1999 08:52:15 -0000
Message-ID: <920019467.2824.1.nnrp-02.9e984b29@news.demon.co.uk>

Before you go to this extreme, have you considered the feature in the newer versions of Oracle that lets you define the isolation level of a transaction as serializable. This may be sufficient for your needs.

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

terrysutton_at_usa.net wrote in message <7b4j3n$nf9$1_at_nnrp1.dejanews.com>...
>We are considering setting a database to Serializable = True to eliminate
>non-repeatable reads.Does anyone have experience with this? What exactly
>are the performance effects? Why shouldn't we do it?--Terry
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Fri Feb 26 1999 - 02:52:15 CST