8.2.4 Metric Data and Alerts

Metric data refers to the collection of data that changes frequently. You can create alerts on the metric data. Oracle GoldenGate delivers predefined metric types and default collection times for each target type.

To view the metric data for a target, click the Target drop-down, select Monitoring, and then click All Metrics. The following are the metric data for Oracle GoldenGate Extract and/or for Replicat targets:
  • Checkpoint Position
  • Name
  • Status
  • Start Time
  • End of File
  • Lag (Sec)
  • Total Inserts
  • Delta Inserts
  • Total Deletes
  • Delta Deletes
  • Total Truncates
  • Delta Truncates
  • Total Operations
  • Delta Operations
  • Delta Operation Per seconds
  • Total Executed DDLs
  • Delta Executed DDLs
  • Total Discards
  • Delta Discards
  • Total Ignores
  • Delta Ignores
  • Last OGG Checkpoint Timestamp
  • Last Processed Timestamp
  • Delta Row Fetch Attemps
  • Delta Row Fetch Failures
  • Total Row Fetch Failures

For more information on the metric data, see Extract and Replicat. The metric data collected is saved to the Management Repository and is compared to the predefined thresholds for each target. If a threshold is reached, then the system generates an alert. The Incidents are displayed on each of the target's homepage.