Re: Drawbacks to Serializable Mode?

From: <manager43_at_my-dejanews.com>
Date: Fri, 26 Feb 1999 08:17:16 GMT
Message-ID: <7b5la7$ke1$1@nnrp1.dejanews.com>

Hi,

Some times ago take attempt to work.
Not simple (only small types of real world relate to this) and Oracle will disable this feature at release 8i (?).

Some information was available approximately 3 years ago when competitors discuss this feature Oracle.

My opinion - this feature was insert in Oracle for better performance results under test TPC-B due to test don't cover such situation. Because now test TPC-D replace this test Oracle discontinued support this feature.

Vladimir

In article <7b4j3n$nf9$1_at_nnrp1.dejanews.com>, terrysutton_at_usa.net wrote:
> 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
>

-----------== 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:17:16 CST