Re: RAC setting for max consistency?

On Sep 14, 6:54 am, sybra..._at_hccnet.nl wrote:
> On Thu, 13 Sep 2007 19:34:55 +0200, Robert Klemme
>
> <shortcut..._at_googlemail.com> wrote:
> >As far as I understand, Oracle does extra work if it detects different
> >branches of the same TX that are tightly coupled. In those cases they
> >can see their respective chances and probably also do not lock each
> >other out of resources. It seems loosely coupled branches just work
> >like two ordinary TX and the only difference is that you can commit them
> >via 2PC.
>
> You are mixing up RAC and distributed databases.
> RAC <> distributed databases.
> Max_commit_propagation_delay has nothing to do with RAC,

You got it wrong, (now depricated) MAX_COMMIT_PROPAGATION_DELAY has everything to do with RAC. You mat want to check out Note:259454.1 "MAX_COMMIT_PROPAGATION_DELAY In A Real Application Clusters Environment".

Regards,
Igor

> Regards,
>
> --
> Sybrand Bakker
> Senior Oracle DBA
Received on Sun Sep 16 2007 - 18:47:21 CDT