Re: Indexing options to avoid contention -- 10gR2

If you're talking about Oracle Streams, then here's the problem with that -- it's not a revenue generator for Oracle because it just comes with EE anyway. It may well be robust technology etc.,but you need very good people to work on it because from some informal discussions I've had, including with Oracle people, support for Streams is not much of a priority.

Our asynchronous CDC solution will be via Informatica PowerExchange, which is really a connector for LogMiner. It has the advantages that we already are licensed for it, we barely need any DBA or other team support to run it, and Informatica set it up for us gratis on our performance test environment.

• Original Message ---- From: Oxnard Montalvo <oxnard_at_carolina.rr.com> To: david_at_david-aldridge.com Cc: oracle-l_at_freelists.org Sent: Wednesday, April 9, 2008 9:46:33 AM Subject: Re: Indexing options to avoid contention -- 10gR2

If your Goal is to perform CDC and you are on 10g or higher I would strongly recommend you check out http://download.oracle.com/docs/cd/B19306_01/server.102/b14223/cdc.htm#i1028295 I have found the CDC process developed by Oracle works very well and solves many of these issues by avoiding them all together.

Ox
--

http://www.freelists.org/webpage/oracle-l Received on Wed Apr 09 2008 - 21:31:10 CDT