Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 9i Streams performance

Re: Oracle 9i Streams performance

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Thu, 07 Apr 2005 11:49:56 +0200
Message-ID: <d32vhr$5hf$1@news4.zwoll1.ov.home.nl>


Matthew wrote:
> 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

Though I have not tested, my understanding was it relied on replication of online redo logs.
Untul your redo log is filled up, no replication will take place. I may be way off, and I could read the fine material, but you should in my place :)

-- 
Regards,
Frank van Bortel
Received on Thu Apr 07 2005 - 04:49:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US