Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Replication Question

RE: Replication Question

From: <>
Date: Fri, 15 Sep 2000 10:11:16 -0400
Message-Id: <>

Hi Phil,

Oracle stores data to replicate in a queue, and pushes the queue to the other db through a database link at regular intervals that you specify. If there's no data to push, the push job does not connect to the other database.

You can push a lot of data. We had a 400Mb network connection (4 lines at 100Mb each somehow spliced together to make 400Mb) and LOTS of disk to replicate one 2 terabyte db to another. The volume was supposed to be 8 million rows a day. I got out before it went production, but the tests we were running were pretty good.

If you do have lots to replicate, and you're really new at this, you may want to bring in a consultant for a week to do an initial knowledge transfer. That helped me tremendously when I started doing replication in earnest (when I went from simple snapshots and a few hundred records to two terabytes and several million).

Boy I miss the days I had real work to do. (Don't tell my boss.)

HTH, Yosi

> -----Original Message-----
> From: Place for oracle []
> Sent: Friday, September 15, 2000 9:10 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Replication Question
> Hello,
> I have some basic rep question and I hope that someone
> can help me with this.
> 1- If there is nothing to replicate does Oracle
> connect to the other db?
> 2- How much data is it possible to replicate ? ( Lets
> say we have big machines and big networdk)
> Regards
> Phil Taylor U.K
> =====
> Place4oracle
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Mail - Free email you can access from anywhere!
> --
> Author: Place for oracle
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Fri Sep 15 2000 - 09:11:16 CDT

Original text of this message