Golden Gate performance - OracleConnections2024-03-28T12:31:12Zhttp://www.oracleconnections.com/forum/topics/golden-gate-performance?feed=yes&xn_auth=noMarvin :
So I'm thinking the…tag:www.oracleconnections.com,2013-06-03:6612035:Comment:73742013-06-03T07:08:48.951ZAsa Labrecquehttp://www.oracleconnections.com/profile/AsaLabrecque
<p><em>Marvin :<br></br></em></p>
<p><em>So I'm thinking the Integrated Capture with the downstream option may help relieve some of..............</em></p>
<p></p>
<p>Yes, that is correct (write downstream capture relieving stress on the source DB).</p>
<p>Regarding integrated extract in general (ie, back on the source DB): It may or may not give you better performance / lower overhead on your source DB, but it is a different capture implementation than traditional extract that takes advantage of…</p>
<p><em>Marvin :<br/></em></p>
<p><em>So I'm thinking the Integrated Capture with the downstream option may help relieve some of..............</em></p>
<p></p>
<p>Yes, that is correct (write downstream capture relieving stress on the source DB).</p>
<p>Regarding integrated extract in general (ie, back on the source DB): It may or may not give you better performance / lower overhead on your source DB, but it is a different capture implementation than traditional extract that takes advantage of some oracle DB internals that allow for new features, not only in terms of functionality but also performance/throughput that wouldn't be possible with the traditional log reader approach.</p> Thanks. I was looking at the…tag:www.oracleconnections.com,2013-06-03:6612035:Comment:73732013-06-03T07:05:35.128ZMarvin Cambrehttp://www.oracleconnections.com/profile/MarvinCambre
<p>Thanks. I was looking at the same links as you. One states "When using Integrated Capture, customers can choose to locate the Capture mechanism at either the source database or an alternate location that is of the same platform type as the source. Performing the capture downstream is useful when it is necessary to minimize overhead at the source database." So I'm thinking the Integrated Capture with the downstream option may help relieve some of the stress on my source DB. What do you…</p>
<p>Thanks. I was looking at the same links as you. One states "When using Integrated Capture, customers can choose to locate the Capture mechanism at either the source database or an alternate location that is of the same platform type as the source. Performing the capture downstream is useful when it is necessary to minimize overhead at the source database." So I'm thinking the Integrated Capture with the downstream option may help relieve some of the stress on my source DB. What do you think? </p> Sorry, in that case, with int…tag:www.oracleconnections.com,2013-06-03:6612035:Comment:74472013-06-03T07:02:05.100ZTom Danielhttp://www.oracleconnections.com/profile/TomDaniel
<p>Sorry, in that case, with integrated capture, the redo logs are still read, and that's done via log mining/create LCR/write to trail. IC supports more data types than does classic capture.</p>
<p>Nothing about it being faster though.</p>
<p><a href="http://www.oracle.com/technetwork/database/availability/8398-goldengate-integrated-capture-1888658.pdf" target="_blank">http://www.oracle.com/technetwork/database/availability/8398-goldengate-integrated-capture-1888658.pdf…</a><br></br></p>
<p>Sorry, in that case, with integrated capture, the redo logs are still read, and that's done via log mining/create LCR/write to trail. IC supports more data types than does classic capture.</p>
<p>Nothing about it being faster though.</p>
<p><a href="http://www.oracle.com/technetwork/database/availability/8398-goldengate-integrated-capture-1888658.pdf" target="_blank">http://www.oracle.com/technetwork/database/availability/8398-goldengate-integrated-capture-1888658.pdf</a><br/> <a href="http://www.oracle.com/technetwork/middleware/goldengate/overview/usingoraclegoldengate11gwithoracle-1539665.pdf" target="_blank">http://www.oracle.com/technetwork/middleware/goldengate/overview/usingoraclegoldengate11gwithoracle-1539665.pdf</a><br/> <a href="https://blogs.oracle.com/dataintegration/entry/oracle_goldengate_11gr2_new_feature" target="_blank">https://blogs.oracle.com/dataintegration/entry/oracle_goldengate_11gr2_new_feature</a></p> Right, but I thought there we…tag:www.oracleconnections.com,2013-06-03:6612035:Comment:75222013-06-03T06:57:47.054ZMarvin Cambrehttp://www.oracleconnections.com/profile/MarvinCambre
<p>Right, but I thought there were other options with Golden Gate that used LCRs instead. I think its Integrated Capture. I'm looking for something that will work best on a system that does lots of DML transactions.</p>
<p>thanks</p>
<p>Right, but I thought there were other options with Golden Gate that used LCRs instead. I think its Integrated Capture. I'm looking for something that will work best on a system that does lots of DML transactions.</p>
<p>thanks</p> Umm, that would be the point…tag:www.oracleconnections.com,2013-06-03:6612035:Comment:76232013-06-03T06:56:07.942ZTom Danielhttp://www.oracleconnections.com/profile/TomDaniel
<p>Umm, that would be the point of reading the redo logs, to see what has been committed or not.</p>
<p>Umm, that would be the point of reading the redo logs, to see what has been committed or not.</p>