OracleConnections

Oracle Community Network

Golden Gate performance

I am running oracle DB 11.2 and am new to Golden Gate. I am trying to replicate the changes from my base database to a new ODS database on a different server. My base DB has a high rate of DML and I am seeing some performance issues. When GG scans the online REDO, it appears to be looking at committed and non-committed transactions. Is there a way to restrict GG to only scan committed transactions?

Thanks

1 member likes this

▶ Reply to This

Replies to This Discussion

Permalink Reply by Tom Daniel on June 3, 2013 at 11:56am

Umm, that would be the point of reading the redo logs, to see what has been committed or not.

▶ Reply

Permalink Reply by Marvin Cambre on June 3, 2013 at 11:57am

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.

thanks

▶ Reply

Permalink Reply by Tom Daniel on June 3, 2013 at 12:02pm

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.

Nothing about it being faster though.

http://www.oracle.com/technetwork/database/availability/8398-golden...
http://www.oracle.com/technetwork/middleware/goldengate/overview/us...
https://blogs.oracle.com/dataintegration/entry/oracle_goldengate_11...

▶ Reply

Permalink Reply by Marvin Cambre on June 3, 2013 at 12:05pm

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?

▶ Reply

Permalink Reply by Asa Labrecque on June 3, 2013 at 12:08pm

Marvin :

So I'm thinking the Integrated Capture with the downstream option may help relieve some of..............

Yes, that is correct (write downstream capture relieving stress on the source DB).

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.