Capturing Change Data with Change Data Capture in Oracle

Change Data Capture can capture and publish committed change data in either of the following modes:

Synchronous:
Change data is captured immediately, as each SQL statement that performs a data manipulation language (DML) operation (INSERT, UPDATE, or DELETE) is made, by using triggers on the source database.

Asynchronous:
Change data is captured after a SQL statement that performs a DML operation is committed, by taking advantage of the data sent to the redo log files.The asynchronous mode of Change Data Capture is dependent on the level of supplemental logging enabled at the source database. There are two methods of capturing change data asynchronously, HotLog and AutoLog.

Advantages of capturing change data with Change Data Capture:
1.Completeness
2.Performance
3.Interface
4.Cost