RE: Slow Streams Performance.

In my environment, I have seen generally it ranges from 1200 LCRs/sec to 2200 LCRs/sec. Though sometimes I have seen 3000LCRs/sec and 1-2 times 4000LCR/sec.
Flow control is always on so I think capture is working fine but Propagation/Apply is not able to catchup.  

2006-11-6 10:42:16 || UNITYD2-> | <F> CP01 2302 2300 6min <F> | Q214596 2333 0 | Q214565 2300 0 | PR01 2389 | - AP01 2335 2 7min -
2006-11-6 10:42:19 || UNITYD2-> | <F> CP01 1787 1785 7min <F> | Q214596 2004 0 | Q214565 1809 0 | PR01 1962 | - AP01 2335 2 7min -
2006-11-6 10:42:22 || UNITYD2-> | <F> CP01 1306 1304 7min <F> | Q214596 1314 0 | Q214565 1309 0 | PR01 1365 | - AP01 2142 2 7min -
2006-11-6 10:42:25 || UNITYD2-> | <F> CP01 1717 1715 7min <F> | Q214596 1629 0 | Q214565 1715 0 | PR01 1621 | - AP01 754 0 7min -
2006-11-6 10:42:28 || UNITYD2-> | <F> CP01 2263 2261 7min <F> | Q214596 2252 0 | Q214565 2233 0 | PR01 2218 | - AP01 1775 2 7min -
2006-11-6 10:42:31 || UNITYD2-> | <F> CP01 3084 3081 7min <F> | Q214596 2966 0 | Q214565 3108 0 | PR01 2986 | - AP01 3003 3 7min -
2006-11-6 10:42:34 || UNITYD2-> | <F> CP01 1419 1418 7min <F> | Q214596 1390 0 | Q214565 1391 0 | PR01 1365 | - AP01 2669 2 7min -
2006-11-6 10:42:37 || UNITYD2-> | <F> CP01 1268 1266 7min <F> | Q214596 1594 0 | Q214565 1277 0 | PR01 1621 | - AP01 812 0 7min -
2006-11-6 10:42:40 || UNITYD2-> | <F> CP01 1902 1900 7min <F> | Q214596 1715 0 | Q214565 1889 0 | PR01 1706 | - AP01 1190 1 7min -  

RE: Slow Streams Performance.

• From: "Luca Canali" <Luca.Canali_at_xxxxxxx>
• To: <oracle-l_at_xxxxxxxxxxxxx>
• Date: Thu, 2 Nov 2006 19:40:40 +0100

Hi Ajay,  

I have tried similar tests and then concluded that the apply processes were the bottleneck. It is not too easy to analyze these kind of problems though. In my test I could see a limit of abbot 4000 LCR/sec. strmmon (from metalink) is a good tool for this kind of analysis. You can also activate 10046 traces on the apply processes. Multiple parallel apply processes often don't increase throughput when inserting in a single table as in you test because they would serialized on buffer busy events (typically on the PK).  

I would be interested in knowing what is the current max LCR/s rate that you are seeing.  

Regards,
Luca

If you are not an intended recipient of this e-mail, please notify the sender, delete it and do not read, act upon, print, disclose, copy, retain or redistribute it. Click here for important additional terms relating to this e-mail. http://www.ml.com/email_terms/

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