Re: Streams advice
From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 22 May 2008 11:50:48 -0700
Message-ID: <1211482263.77405@bubbleator.drizzle.com>
>
> Performance within the source? Thought that the only real additional
> overhead there would be the requirement to bump to supplemental rather
> than standard logging. Does the log mining process affect performance
> within the source database process?
>
> GM
Date: Thu, 22 May 2008 11:50:48 -0700
Message-ID: <1211482263.77405@bubbleator.drizzle.com>
Geoff Muldoon wrote:
> Frank van Bortel says...
>> 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.
>
> Performance within the source? Thought that the only real additional
> overhead there would be the requirement to bump to supplemental rather
> than standard logging. Does the log mining process affect performance
> within the source database process?
>
> GM
Log Miner is very resource intensive. Don't be surprised if it eats a substantial percentage of your server's capabilities.
-- 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 Thu May 22 2008 - 13:50:48 CDT