This appendix describes the attributes (also called "monitoring points") captured by Oracle GoldenGate Monitor. Metrics apply to both Extract and Replicat targets. The attributes reported for Oracle GoldenGate Monitor are:
Shows a composite representation of the checkpoints that were persisted to disk most recently by Extract or Replicat. The value is captured by the monitoring Agent when the metric is published, right after the checkpoint gets persisted.
Extract creates read and write checkpoints, and Replicat creates only read checkpoints. Each individual checkpoint within the composite Checkpoint Position consists of the RBA (relative bye address) of a record in the transaction log or trail (depending on the process and whether it is a read or write checkpoint) and the sequence number of the log or trail file that contains the record. There can be a series of read checkpoints in multiple data source log files (such as Extract from Oracle Real Application Cluster), and/or multiple write checkpoints such as in Extract configurations with multiple trail files.
Accepted Values: Different databases use different representations of the position of a record in the log. Therefore, instead of numeric values, Checkpoint Position is published as a string of text characters encoded in UTF8. For each individual checkpoint within Checkpoint Position, the following are shown the way that they are returned by the GGSCI SEND group-name STATUS command:
The values of the RBA (relative byte address)
The file sequence number
The time stamp
Valid for Instance, Capture, Data Pump, Delivery.
Shows whether or not the Oracle GoldenGate Monitor Server can connect to the Oracle GoldenGate Monitor Agent that is running within the Oracle GoldenGate Instance.
Accepted Values: Connected or Disconnected
Shows the number, since the metric was last reported, of DELETE operations that were processed by the selected Oracle GoldenGate process in its current run session.
Accepted Values: A positive integer
Shows the number, since the metric was last reported, of DISCARD operations that were processed by the selected Oracle GoldenGate process in its current run session. The records are written to the discard file that is associated with the process.
Accepted Values: Positive integer.
Shows the count of executed data definition language (DDL) operations that were processed by the selected Oracle GoldenGate process since the last sample time.
Accepted Values: Positive integer
Shows the number of data manipulation language (DML) operations that were ignored since the last sample time.
Accepted Values: Positive integer
Shows the number of DML INSERT operations that were processed by the selected Oracle GoldenGate process since the last sample.
Accepted Values: A positive integer
Shows the number of operations (per second) that were processed by the selected Oracle GoldenGate process since the last sample.
Accepted Values: A positive integer
Shows the number of operations that were processed by the selected Oracle GoldenGate process since the last sample.
Accepted Values: A positive integer
Shows the number of row fetch attempts that were processed by the selected Oracle GoldenGate process since the last sample. A fetch must be done occasionally to obtain row values when the information is incomplete or absent in the transaction log.
Accepted Values: Positive integer
Shows the number of row fetches that the selected Oracle GoldenGate process failed to complete since the last sample. A fetch must be done occasionally to obtain row values when the information is incomplete or absent in the transaction log
Accepted Values: Positive integer
Shows the number of TRUNCATE operations that were processed by the selected Oracle GoldenGate process in its current run session since the last sample.
Accepted Values: A positive integer
Shows the number of UPDATE (including primary key updates) operations that were processed by the selected Oracle GoldenGate process in its current run session since the last sample.
Accepted Values: A positive integer
Shows whether or not the selected Oracle GoldenGate process has reached the end of the input from its data source (transaction log or trail file).
Accepted Values: TRUE (at end of file) or FALSE
Valid for Instance.
Indicates the version of Oracle GoldenGate that the selected Oracle GoldenGate Instance represents.
Accepted Values: X.x.x (major, minor, and maintenance version levels), for example 11.1.1
Valid for Capture, Data Pump, Delivery.
Shows the name of the process group that is associated with the selected process. A process group is a logical identifier that also includes the checkpoint file, parameter file, and other files that are associated with a specific instance of a process type.
Accepted Values: The alphanumeric name of the group as it was specified when ADD EXTRACT or ADD REPLICAT was issued in GGSCI, for example oggext
Valid for Host.
Shows the name of the host system that is selected in the Navigation Tree or Diagram View.
Accepted Values: The fully qualified DNS name of the host, or its IP address
Shows the time difference between the Last Operation Timestamp and the Last Processed Timestamp. This metric represents the true lag between the Oracle GoldenGate process and its data source. This lag value should match the value that is returned from the GGSCI command SEND group GETLAG.
Accepted Values: The lag time, in seconds
Shows the time when the last checkpoint was written by the Oracle GoldenGate process.
Accepted Values: Date-time value in the format of MM/DD/YYYY HH:MM:SS {AM | PM}, for example: 01/14/2013 09:36:32 AM.
Shows the time when an operation was committed in the data source, as recorded in the transaction log.
Accepted Values: Date-time value in the format of MM/DD/YYYY HH:MM:SS {AM | PM}, for example: 01/14/2013 09:36:32 AM
Shows the time when a valid record was returned to the selected Oracle GoldenGate process. For Extract, this time value is assigned when the record is processed after the container transaction commits (not the time when the record is read from the transaction log). For a Data Pump or Replicat, this time value is returned immediately, because all transactions in the trail are known to be committed.
Accepted Values: Date time value in the format of MM/DD/YYYY HH:MM:SS {AM | PM}, for example: 01/14/2013 09:36:32 AM
Valid for Instance.
Shows the port on which the Manager process of the Instance is running on its local system. The default port number is 7809, but a different port could be specified for this Manager and can be identified by viewing the Manager parameter file or by issuing the INFO MANAGER command in GGSCI (if Manager is running).
Accepted Values: The port number for the Manager process, as specified in the Manager parameter file.
Valid for Capture, Data Pump, Delivery.
Shows the total number of INSERT operations that were processed by the selected Oracle GoldenGate process in its current run session. The statistic reflects the total operations performed on all of the tables that are specified in the parameter file for that process.
Note:
If any tables are mapped to targets in the Capture configuration, the statistics will reflect the total operations for all of the targets.Accepted Values: A positive integer.
Valid for Capture, Data Pump, Delivery.
Shows the total number of UPDATE (including primary key updates) operations that were processed by the selected Oracle GoldenGate process in its current run session. The statistic reflects the total operations performed on all of the tables that are specified in the parameter file for that process.
Note:
If any tables are mapped to targets in the Capture configuration, the statistics will reflect the total operations for all of the targets.Accepted Values: A positive integer.
Valid for Capture, Data Pump, Delivery.
Shows the total number of DELETE operations that were processed by the selected Oracle GoldenGate process in its current run session. The statistic reflects the total operations performed on all of the tables that are specified in the parameter file for that process.
Note:
If any tables are mapped to targets in the Capture configuration, the statistics will reflect the total operations for all of the targets.Accepted Values: A positive integer.
Valid for Capture, Data Pump, Delivery.
Shows the total number of TRUNCATE operations that were processed by the selected Oracle GoldenGate process in its current run session. The statistic reflects the total operations performed on all of the tables that are specified in the parameter file for that process.
Note:
If any tables are mapped to targets in the Capture configuration, the statistics will reflect the total operations for all of the targets.Accepted Values: A positive integer.
The message includes the following information:
Component attribute: Show the name of the component; for example: ONLEXT / ONLREP.
Message code: Number of an event message from the Oracle GoldenGate error log.
Accepted Values: The numerical code of an Oracle GoldenGate event message in the event log, for example, OGG-00651.
Message Date: Timestamp of an event message from the Oracle GoldenGate log.
Accepted Values: A date-time value in the form of YYYY-MM-DD HH:MM:SS (in 24-hour clock format)
Message Text: Text of an event message from the Oracle GoldenGate error log.
Accepted Values: A text string from the message.
Valid for Capture, Data Pump, Delivery, Instance.
Shows the code number of an event message from the Oracle GoldenGate error log.
Accepted Values: The numerical code of an Oracle GoldenGate event message in the event log, for example OGG-00651.
Valid for Capture, Data Pump, Delivery, Instance.
Shows the timestamp of an event message from the Oracle GoldenGate log.
Accepted Values: A date-time value in the form of YYYY-MM-DD HH:MM:SS (in 24-hour clock format)
Valid for Capture, Data Pump, Delivery, Instance.
Shows the severity of a message in the Oracle GoldenGate event log.
Accepted Values: INFO, WARNING, ERROR
Valid for Capture, Data Pump, Delivery, Instance.
Shows the text of an event message from the Oracle GoldenGate error log.
Accepted Values: A text string from the message
Name of the selected object.
Accepted Values: Name of the object as displayed in the Oracle GoldenGate Monitor interface.
Valid for Trail.
Shows the path name of the selected trail.
Accepted Values: The relative or full path name of the trail, appended with the two-character logical name, for example dirdat/tr.
Time (in seconds) since the last Oracle GoldenGate checkpoint.
Shows the time that an Oracle GoldenGate component received its startup information after it has been created.
Accepted Values: 64-bit Julian GMT time stamp in microseconds
Shows the run status of the selected Oracle GoldenGate process.
Accepted Values: Starting, Running, Stopped, Abended, or Aborted.
Shows the total number of DELETE operations that were processed by the selected Oracle GoldenGate process in its current run session.
Accepted Values: A positive integer
Shows the total number of operations that were discarded by the selected Oracle GoldenGate process in its current run session. The records are written to the discard file that is associated with the process.
Accepted Values: Positive integer.
Shows the total number of DDLs operations that were processed by the selected Oracle GoldenGate process in its current run session.
Accepted Values: Positive integer
Shows the total number of DML operations that were ignored by the Oracle GoldenGate process in its current run session. Errors are included in the Total Ignores metric.
Accepted Values: Positive integer
Shows the total number of DML INSERT operations that were processed by the selected Oracle GoldenGate process in its current run session. The statistic reflects the total operations performed on all of the tables that are specified in the parameter file for that process. Note: If any tables are mapped to targets in the Extract configuration, the statistics will reflect the total operations for all of the targets.
Accepted Values: A positive integer
Shows the total number of operations that were processed by the selected Oracle GoldenGate process since the last sample.
Total operations = total DML changes (insert, update, delete) + total DDL (table definition changes) + Truncate changes
Accepted Values: A positive integer
Shows the total number of row fetches that the selected Oracle GoldenGate process performed in its current run session. A fetch must be done sometimes to obtain row values when the information is incomplete or absent in the transaction log.
Accepted Values: Positive integer
Shows the total number of row fetches that the selected Oracle GoldenGate process was unable to perform in its current run session.
Accepted Values: Positive integer
Shows the total number of TRUNCATE operations that were processed by the selected Oracle GoldenGate process in its current run session. The statistic reflects the total operations performed on all of the tables that are specified in the parameter file for that process. Note: if any tables are mapped to targets in the Extract configuration, the statistics will reflect the total operations for all of the targets.
Accepted Values: A positive integer
Shows the total number of UPDATE (including primary key updates) operations that were processed by the selected Oracle GoldenGate process in its current run session. The statistic reflects the total operations performed on all of the tables that are specified in the parameter file for that process. Note: If any tables are mapped to targets in the Extract configuration, the statistics will reflect the total operations for all of the targets.
Valid for Database.
Shows the type of database. Examples are Oracle and SQL Server.
Accepted Values: The alphanumeric brand name of the database.
Valid for Database.
Shows the version of the database.
Accepted Values: X.x.x (major, minor, and maintenance version levels), for example 11.1.1.
Valid for Instance.
Shows the directory that contains the Manager executable file for the selected Oracle GoldenGate Instance. This is the home directory of the Oracle GoldenGate installation.
Accepted Values: The full path name of the directory