Re: Streams advice
From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 21 May 2008 08:57:47 -0700
Message-ID: <1211385482.324204@bubbleator.drizzle.com>
>
> No - source. Hopefully, things have improved with 10G; 9.2.0.4 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!
> Welcome.
>
> FvB
Date: Wed, 21 May 2008 08:57:47 -0700
Message-ID: <1211385482.324204@bubbleator.drizzle.com>
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; 9.2.0.4 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, 9.2.0.4 is not where you would want to be today.
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Wed May 21 2008 - 10:57:47 CDT