Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 9i Streams performance
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 BortelReceived on Thu Apr 07 2005 - 04:49:56 CDT