High performance replication ?

From: Andras Kovacs <andkovacs_at_yahoo.com>
Date: 18 Jan 2004 13:52:32 -0800
Message-ID: <412ebb69.0401181352.4d9b8c2d@posting.google.com>

We have a performance problem to replicate our environnement.

Our java code is able to insert 100 000 rows in a table within 3 seconds using Batch Statement. For two oracle sites it takes 6 seconds the inserts. When we enable oracle's advanced replication the time falls to 44 seconds for the two replicated sites. So the transactions took 7 times more time. It is normal Oracle states that Adv replication takes around 6 times more resource than ordinary transactions.

Then we disabled Oracle's Adv replication and created a trigger that replicates the data from from site to the other. The transactions again took 44 seconds.

Unfortuantely Oracle internal replication design doesn't recognize Batch Updates.

Is there a way to improve the replication's performance ?

NB: Unfortunately the standby option has been discarded by the managers .... Received on Sun Jan 18 2004 - 15:52:32 CST