Re: Procedural Replication

David Turner wrote:
>
> I have heard numbers of about 100-800 transactions per minute as the limit for Oracle
> replication, but does anyone know if this would include procedural replication. If so
> does anyone out there know of some better solutions for replicationg a really high
>number
> of transactions across a WAN.
>
> Thanks, Dave Turner
> --

Dave,

  I know an investment bank which for the past years has been using an in-house, trigger-based, almost real-time (a change in London or Paris is usually replicated in Tokyo within 4-5 seconds) WAN replication between 10 machines in the Europe-centered network and I think 12 in the Asia centered-network (I say 'centered' because Singapore, New-York, Tokyo and London are in both loops, although different machines and databases are involved). I don't know exactly the peak transfer rate, because it works by bursts, but I can tell you that around market closure there is a lot of traffic. And yet there is ample scope for improvement in their system. Unless you are after an off-the-shelf solution, e-mail me off-list if you want details.

-- 
Regards,

Stephane Faroult
Oriole Corporation
Voice:  +44  (0) 7050-696-269 
Fax:    +44  (0) 7050-696-449 
Performance Tools & Free Scripts
--------------------------------------------------------------
http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
--------------------------------------------------------------
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriole.com

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: ListGuru_at_fatcity.com (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).