Re: streams capture performance

Hazem,

Sorry for the delay.
The SPILL_MSGS is 0 but the CSPILL_MSGS is non-zero. CNUM_MSGS:462144 CSPILL_MSGS:104204 Any ideas on what I can do to speed up the capture process speed? I have already set the parallelism to 4 but don't see any evidence of that making a difference.
We have a six node RAC, so the archives get generated on all six nodes but the capture process is essentially a single process trying to read thru all the redo/archive files generated from all nodes. It almost appears to be a design limitation to me.

Thanks.

On Thu, Oct 16, 2008 at 8:29 AM, Hazem Ameen <hazem.ameen_at_gmail.com> wrote:

> Madhu,
>
>
>
> Do you have any spilling under *V*$BUFFERED_QUEUES for you capture queue?
>
>
>
> I've seen a situation where streams_pool_size is NOT dynamically resized
> even though ASMM is enabled
>
>
>
> Hazem
>

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