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 ....