Book Image

Oracle GoldenGate 12c Implementer's Guide

Book Image

Oracle GoldenGate 12c Implementer's Guide

Overview of this book

Table of Contents (21 chapters)
Oracle GoldenGate 12c Implementer's Guide
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
GGSCI Commands
GoldenGate Installed Components
Acronyms
Index

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 information related to the performance of Streams, GoldenGate, and XStream in the following sections of the AWR report:

    • Replication statistics (GoldenGate and XStream)

    • Streams statistics

As a footnote, Oracle XStream is built on the infrastructure...