Re: Streams advice

From: DA Morgan <>
Date: Wed, 21 May 2008 08:57:47 -0700
Message-ID: <>

Frank van Bortel wrote:
> Geoff Muldoon wrote:

>> We are particularly looking at Asynchronous Change Data Capture 
>> because it "can be configured to have minimal performance impact on 
>> the source database", so I presume you refer to overheads at the 
>> staging database and overall server resource levels, rather than 
>> within the source databases.  Maybe overheads of the subscriber 
>> databases too?

> No - source. Hopefully, things have improved with 10G; was
> simply a disaster.
> Oh - and do not forget about maintenance on Streams; if something
> goes wrong, you're probably screwed. try to test and break things,
> and see if you can get them repaired. And document that thoroughly!
>> Thanks for your thoughts, appreciated.

> Welcome.
>> Geoff M

> FvB

There are some excellent papers on debugging Streams issues at metalink. But, of course, is not where you would want to be today.

Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Wed May 21 2008 - 10:57:47 CDT

Original text of this message