[askdba] Re: Bandwidth calculation and data transfer calculation

  • From: "Justin Cave (DDBC)" <jcave@xxxxxxxxxxx>
  • To: <askdba@xxxxxxxxxxxxx>
  • Date: Wed, 13 Jul 2005 08:06:48 -0600

I'm assuming here that by replication you mean materialized views.  If
you are using Data Guard, Streams, or some other technology, the answer
may be slightly different.

With any network protocol, there is going to be a degree of overhead
above and beyond the payload of data that actually has to be
transferred.  The simplest way to measure that overhead, and to
determine how that overhead affects performance (different types of
overhead will affect different types of networks differently) would be
to do a test.  If you expect to replicate, say, 1,000,000 records a day,
set up a test where you replicate 10,000 records (1%), and see how long
that takes.  Repeat the test with 2%, 4%, 8%, etc. until you have an
appropriate degree of confidence about how long replicating the real
data will take and how much bandwidth will be consumed.

Justin Cave  <jcave@xxxxxxxxxxx>
Distributed Database Consulting, Inc.

-----Original Message-----
From: askdba-bounce@xxxxxxxxxxxxx [mailto:askdba-bounce@xxxxxxxxxxxxx]
On Behalf Of Subodh Deshpande
Sent: Wednesday, July 13, 2005 8:21 AM
To: askdba@xxxxxxxxxxxxx
Subject: [askdba] Bandwidth calculation and data transfer calculation

Dear All,

We are replicating some objects from one site to another.

I would like to measure the time taken for the replication of data from
one location to another.

What is the simplest mesaurable method I should use.

From Avg Rec length and num of records I can get the data to be
transferred/replicated..and the network engineer does not agree with
this..he says its more than that..

can any ideas..

Good Luck..Subodh Deshpande

Experience Is Knowledge
Wisdom Is Philosophy

NEW! Lycos Dating Search. The only place to search multiple dating sites
at once.

Other related posts: