Que 1: What are the most popular CDC options available?
Ans:
Oracle 9.2 has a CDC sync function. - works out of the hot logs.
Oracle streams works async through the CDC development framework
Que 2: How does the Oracle CDC work?
Ans:
Oracle CDC in 9i functioned synchronous through Hot logs, which meant that the preformance overhead on the transactions were very high.
Oracle 10g is a huge saving on the cost of performance as it only inspects the redo logs to capture transaction meta data and uses streams for queuing changed data.
Que3: what is the difference between Oracle Streams and the CDC function in Oracle9.2?
Oracle Streams is Asynchronous and the Oracle database is not running in a archive log mode.
Ans:
Oracle9i cdc function is synchronous and needs oracle to run in an Archive log mode.
Que4: what are the applications of Oracle CDC?
Ans:
1. Can be a very prodcutive ETL operations.
2. Can optimize the functioning or Oracle Data warehouse. |
