473,728 Members | 1,947 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 3309

"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
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
1423
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.
0
1187
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
1
2011
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.
0
1140
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
5
2472
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...
0
1401
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...
4
3499
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.
2
1544
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...
2
151
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 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...
0
8903
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9422
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
9198
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9130
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8129
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
4524
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4792
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3236
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2161
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.