By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,502 Members | 1,878 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,502 IT Pros & Developers. It's quick & easy.

High performance replication ?

P: n/a
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 ....
Jul 19 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a

"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
Jul 19 '05 #2

P: n/a
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.
Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.