Re: Replication : database triggers vs log sniffing

From: Michael Ho <infoage_at_hk.super.net>
Date: 1997/04/30
Message-ID: <3367C5A0.19D5@hk.super.net>#1/1

voodoo wrote:
>
> Hello,
>
> Is there anyone out there who knows why database tiggers used in
> oracle's replication are BETTER than log sniffing used in other
> databases? is log sniffing faster ?? unfortunately i have no idea what
> database uses log sniffing . I need this information in order to
> convince a hopefully future user of oracle.
> It is Better ?!! Isn't it.
> any information would be very helpfull - Thanks.

They are the same thing. The Oracle Advanced Replication Option will setup triggers and packages which will generate replication logs. Those logs will be used by the replication jobs to replicate the data.

It is a normal and sensible way to implement Replication. Also the performance, in my experience, is reasonably good. Received on Wed Apr 30 1997 - 00:00:00 CDT