dba_capture_prepared_database

This view displays information about when the local database was prepared for the instantiation. If the local database was not prepared for instantiation, this view contains no rows.

dba_capture_prepared_schemas

This view displays information about the schemas prepared for instantiation in the local database. Whenever a schema is not prepared for instantiation, it fails to capture and apply the database changes.

dba_capture_prepared_tables

This view displays information about the tables prepared for instantiation in the database. When the data system consists of a large number of tables, it is important to ensure that the desired tables are prepared for instantiation. This helps to troubleshoot the Capture process. Whenever a table is not prepared for instantiation, it fails to capture and apply the database changes.  In turn, this has a negative impact on overall performance.

In the following section, some SQL statements will be presented that can be used to view the configuration of the Capture process and to monitor the Streams Capture process details.