Static data dictionary views

Three new static data dictionary views related to data replication have been introduced with the Oracle 12c database Version 12.1.0.1. The following views are designed to be used in accordance with the database's AWR report:

  • DBA_HIST_CAPTURE: This displays the historical statistics information about each capture process for Oracle Streams, Oracle GoldenGate, and XStream capture operations.
  • DBA_HIST_APPLY_SUMMARY: This displays the historical statistics information about each apply process for Oracle Streams, Oracle GoldenGate, and Oracle XStream.
  • DBA_HIST_REPLICATION_TBL_STATS: This displays replication table statistics for Oracle GoldenGate and XStream sessions. The information collected in this view is used to display ...

Get Oracle GoldenGate 12c Implementer's Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial