Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Slow Streams Performance.

RE: Slow Streams Performance.

From: Thotangare, Ajay \(GTI\) <Ajay_Thotangare_at_ml.com>
Date: Mon, 6 Nov 2006 14:39:22 -0500
Message-ID: <E91392BCB7BF9F409939B5E730164B0007A03CA3@MLNYA210MB.amrs.win.ml.com>


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.

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
Received on Mon Nov 06 2006 - 13:39:22 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US