A Attributes
Checkpoint Position
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
Connected | Disconnected
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
Delta Deletes
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
Delta Discards
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.
Delta Executed DDLs
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
Delta Ignores
Shows the number of data manipulation language (DML) operations that were ignored since the last sample time.
Accepted Values: Positive integer
Delta Inserts
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
Delta Operation Per Second
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
Delta Operations
Shows the number of operations that were processed by the selected Oracle GoldenGate process since the last sample.
Accepted Values: A positive integer
Delta Row Fetch Attempts
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
Delta Row Fetch Failures
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
Delta Truncates
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
Delta Updates
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
End of File
Shows whether or not the selected 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
GGS Version
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
Group Name
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
Host Name
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
Lag
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
Last Checkpoint Timestamp
Shows the time when the last checkpoint was written by the 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.
Last Operation Timestamp
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
Last Processed Timestamp
Shows the time when a valid record was returned to the selected 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
Manager Port
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.
Mapped Total Inserts
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.
Mapped Total Updates
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.
Mapped Total Delete
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.
Mapped Total Truncates
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.
Message
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.
Message Code
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.
Message Date
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)
Message Severity
Valid for Capture, Data Pump, Delivery, Instance.
Shows the severity of a message in the Oracle GoldenGate event log.
Accepted Values: INFO
, WARNING
, ERROR
Message Text
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
Name of the selected object.
Accepted Values: Name of the object as displayed in the Oracle GoldenGate Monitor interface.
Path
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
.
Start Time
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
Status
Shows the status of the selected process.
Accepted Values: Unknown, Registered, Initializing, Running, Stopping, Forced Stopping, Stopped, Forced Stop, Abended, Killed, and Unresponsive
Total Deletes
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
Total Discards
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.
Total Executed DDLs
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
Total Ignores
Shows the total number of DML operations that were ignored by the process in its current run session. Errors are included in the Total Ignores metric.
Accepted Values: Positive integer
Total Inserts
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
Total Operations
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
Total Row Fetch Attempts
Shows the total number of row fetches that the selected 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
Total Row Fetch Failures
Shows the total number of row fetches that the selected process was unable to perform in its current run session.
Accepted Values: Positive integer
Total Truncates
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
Total Updates
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.
Type
Valid for Database.
Shows the type of database. Examples are Oracle and SQL Server.
Accepted Values: The alphanumeric brand name of the database.
Version
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.