Re: Replication question

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Thu, 24 Jun 1999 09:07:46 -0700
Message-ID: <377257D2.46AF3B92@us.oracle.com>

Joe

Like so many things, the answer to your question is "It depends." There were many performance improvements in Oracle8 replication, including the internalizing of the triggers you mention, but also improvements in parallelization, the amount of network traffic generated etc.

In general, my experience has been that performance with 7.3 maxed at a throughput of about 10-15 tps, but this is very dependent on the application. With 8, I've seen figures anywhere in the range of 20-100 tps, but again, it's very dependent on the application. The only real way to get accurate figures is volume test, volume test, volume test.

HTH. Pete

Joe Pitt wrote:

> I read somewhere that in Oracle7 the replication code was PL/SQL and that
> with Oracle8 it was re-implemented in C code - which would provide better
> performance. I was wondering if anyone had used replication in Oracle7 and
> subsequently migrated to Oracle8 and could comment on any changes in
> performance?

Regards

Pete

Received on Thu Jun 24 1999 - 11:07:46 CDT