Oracle 9i Streams performance

From: Matthew <matthew_glen_evans_at_hotmail.com>
Date: 7 Apr 2005 02:39:55 -0700
Message-ID: <4f49e314.0504070139.b93e95f@posting.google.com>

Hi,

We are looking to implement a streams based replication environment with transformations.

The platform is as follows:

select * from v$version;

Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production PL/SQL Release 9.2.0.6.0 - Production
CORE 9.2.0.6.0 Production
TNS for IBM/AIX RISC System/6000: Version 9.2.0.6.0 - Production NLSRTL Version 9.2.0.6.0 - Production

I have done some prototyping using a couple of (admittedly underpowered) virtual machine installations, and we are seeing *very* high latency (upwards of 10 mins to replicate one insert)

My sense of streams is that they are designed to provide high speed near time replication. Does anyone have any comment?

TIA, Matthew Received on Thu Apr 07 2005 - 04:39:55 CDT