Re: Transaction Management

From: RSH <RSH_Oracle_at_worldnet.att.net>
Date: Tue, 04 Jun 2002 22:27:06 GMT
Message-ID: <_8bL8.21601$LC3.1609323@bgtnsc04-news.ops.worldnet.att.net>

Conflict Resolution is normally a gruesome DBA task when you have Oracle Enterprise running and have ARO or SRO running across instances either on the same machine or through a network of systems. The DBA has to decide what happens when Oracle cannot make up its mind on its own.

(Advanced Replication Option, Symmetric Replication Option) Where is my Vioxx when I need it?

If your system is that sensitive to atomicity and synchrony, you may want to consider a third party TPM (teleprocessing monitor) such as BEA's (formerly Bell Lab's) Tuxedo and use the XA interfaces to Oracle. Oracle has a few tricks in its bag along these lines too, lately.

Identify and analyze just what your critical business decision points are; that may help you decide how complicated you want to get in fixing them.

RSH.
"Sted Alana" <Sted_Alana_at_hotmail.com> wrote in message news:3cf8cb5a_1_at_news.iprimus.com.au...
> To All:
>
> 1) What is the purpose of testing for serializability of a transaction
> schedule?
>
> 2) Why is the relevance of view equivalence and conflict equivalence?
>
> 3) How to test if a transaction schedule is 2PL?
>
>
> Any suggestions appreciated.
>
> --
> N e w s N e t C u s t o m e r
> E - m a i l : sted.alana_at_hotmail.com
>
>
>
>
>
>
Received on Tue Jun 04 2002 - 17:27:06 CDT