High performance replication ?

[Andras Kovacs]

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

[Jim Kennedy]

"Andras Kovacs" <an*******@yahoo.com> wrote in message
news:41**************************@posting.google.c om...

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

[Andras Kovacs]

Sorry I have forgotten to put some useful info:
1. Oracle is 9.2.0.4 Entreprise Edition
2. Window 2000 adv
3. Java statement is executeBatch and addBatch
4. We are looking for a similar command in Oracle SQL or PL/SQL or
Trigger staff that runs as fast as executeBatch in Java.