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

Jul 19 '05 #1

Subscribe Reply

3311

Jim Kennedy

"Andras Kovacs" <an*******@yaho o.com> wrote in message
news:41******** *************** ***@posting.goo gle.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 :
"Unfortuant ely 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

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.

Jul 19 '05 #3

Similar topics

1425

Data Replication performance.

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 performance bottlenecks for each database when performing replication, or can point me to a white paper or webpage.

Microsoft SQL Server

1189

sql server replication performance

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 as transactional replications. Is there any way to fine tune the sql server, so that replication will

Microsoft SQL Server

2015

DB2 V7 Replication performance

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 replication. I thought that the apply might be the one causing this but after capturing the SQL statements it looks like the capture process is causing those IO's.

DB2 Database

1141

Performance problem after replication

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. Before the replication, the delay was acceptable for the end users. After the replication and the modification I have done in order to make

DB2 Database

2473

Replication performance - how to measure it ?

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 configured, I prepared set of data using DBGEN from TPC and I already imported them into databases.Also, I configured the replication. Now I have to do a test with a few kind of replications method implemented in these RDMBS, but I don't know which...

Microsoft SQL Server

1403

Replication merge instance is not find in Performance Viewer

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 subscription database table and I find publication machine database table also updated with subscription database table, here my problem starts, My problem is when I run replication for merge transaction, I have to find instance of the Windows on my...

Microsoft SQL Server

3508

DB2 Tools/tuning to help performance over high network latency sites?

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 for an assembly with many parts, from remote locations, the performance goes out the window. Locally, it all works fine because network latency is <1ms. But some remote sites we have (that are growing) latency can be as high as 80-100ms.

DB2 Database

1545

SQL2005 performance problem

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 be part of the replicating group. However, since importing these records (using 'Import Data' to get the data in and then running a no-change update to make replication aware of them) the performance has become dreadful. The hard-drive is swamped...