Re: High performance replication ?

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Sun, 18 Jan 2004 22:00:41 GMT
Message-ID: <dmDOb.94955$xy6.170105@attbi_s02>

"Andras Kovacs" <andkovacs_at_yahoo.com> wrote in message news:412ebb69.0401181352.4d9b8c2d_at_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 ....

Not sure what you mean.

1. No Oracle version.  That helps.
2. No OS information or version.
3. What type of replication, sync pr async? (master master, what)
4. Not sure what the statement :

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

means. It does not seem to follow from the other statements.

Are you trying to solve a performance/through put problem or a high availability problem. (granted if the system is unavailable that is a performance problem.)

You don't provide enough information to make a guess as to what the answer is.
Jim Received on Sun Jan 18 2004 - 16:00:41 CST