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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
