473,322 Members | 1,314 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

High performance replication ?

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
2 3268

"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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Tobias Johansson | last post by:
I'm seearching for information regarding database replication performance. We need to compare the performance of replication for SQL Server and Oracle and it is urgent! Anyone who can describe the...
0
by: J | last post by:
Hi There, I would be glad if someone helps me. My company has around 25 big databases and they are being replicated to our second server after some intervals. We are using snapshot as well...
1
by: Gert van der Kooij | last post by:
Hi, We are replicating over 200 tables from each production 'server' (13 at the moment, about 140 when all are configured) and noticed a large amount of additional IO's after activating...
0
by: Andy K | last post by:
Hi, After a replication between 2 databases, performance problem has appeared with the master database. The database is a 2 tiers application where web frontal is targeting this database....
5
by: mjan | last post by:
Hello, could you please advice on how to measure replication performance in Oracle, DB2 & MS SQL Server RDBMS installed in Windows servers ? I've got two servers with databases installed and...
0
by: sk.rasheedfarhan | last post by:
Hi all, I set the configuration for Merge replication for Subscription on one database and I have created the Merge replication for publication on another machine. And I updated columns of...
4
by: 73k5blazer | last post by:
Hello again all.. We have a giant application from a giant software vendor that has very poor SQL. It's a PLM CAD application, that makes a call to the db for every cad node in the assembly. So...
2
by: Jim | last post by:
We have an installed site with two SQL2005 servers (workgroup, SP2). At the publisher we recently (yesterday) bulk inserted about 2million lines into a table from a third server that's going to...
2
by: Andras Kovacs | last post by:
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...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.