One of the new features in Oracle 10g is Fast Incremental Backups, which require that databases be run with Block Change Tracking enabled. While the usage of Fast Incremental Backups has been discussed quite thoroughly in recent years, the internals of the change-tracking feature implementation in Oracle 10g are still obscure.
This presentation will show how change-tracking works inside an Oracle instance, and what CTWR process does. It will illustrate how other processes are involved and discuss the overhead caused by Block Change Tracking. This information is obtained by the means of experiments and advanced research techniques.