Re: streams capture performance

On Wed, Oct 15, 2008 at 7:23 PM, GovindanK <gkatteri_at_fastmail.fm> wrote:

> When you said Best Practice Docs did you mean Metalink Note # 335516.1 ?
>
>
> Did you look at Note:365648.1 , 273674.1 ; How many capture process are
> running? Does the difference always stay at 12 hrs or it picks up sometime?
>
> GovindanK
>
> On Wed, 15 Oct 2008 17:38:54 -0500, "Madhu Sreeram" <
> madhusreeram_at_gmail.com> said:
>

 Yes the note#335516.1 as well as many other documents in metalink under the "streams" knowledge browser.
Note#365648.1 seems to be relevant only for apply. I have looked at the output of Health check specified in #273674.1 but nothing obvious. I have only one capture process running (there is just one capture queue), however I set the parallelism to 4 (using: dbms_capture_adm.set_parameter) but found no improvement with the default (=1) . The latency has stayed mostly the same and I do see that log miner is processing archives constantly.

-Madhu S

--
http://www.freelists.org/webpage/oracle-l