1. Oracle GoldenGate Classic Documentation
  2. Administer
  3. Data Management
  4. Using Procedural Replication
  5. Monitoring Oracle GoldenGate Procedural Replication

Monitoring Oracle GoldenGate Procedural Replication

A set of data dictionary views enable you to monitor Oracle GoldenGate procedural replication.

You can use the following views to monitor Oracle GoldenGate procedural replication:

View Description

DBA_GG_SUPPORTED_PACKAGES

Provides details about supported packages for Oracle GoldenGate procedural replication.

When a package is supported and Oracle GoldenGate procedural replication is on, calls to subprograms in the package are replicated.

DBA_GG_SUPPORTED_PROCEDURES

Provides details about the procedures that are supported for Oracle GoldenGate procedural replication.

DBA_GG_PROC_OBJECT_EXCLUSION

Provides details about all database objects that are on the exclusion list for Oracle GoldenGate procedural replication.

A database object is added to the exclusion list using the INSERT_PROCREP_EXCLUSION_OBJ procedure in the DBMS_GOLDENGATE_ADM package. When a database object is on the exclusion list, execution of a subprogram n the package is not replicated if the subprogram operates on the excluded object.

  1. Connect to the database as sys (sqlplus, sqlcl, or sqldeveloper) not as an Oracle GoldenGate administrator.
  2. Query the views related to Oracle GoldenGate procedural replication.