Oracle GoldenGate Replicat

Table 1-372 Supported Status and Performance Metrics for GoldenGate Replication

Metric Group	Category	Name	Unit	Description
Replicat Position	Response	Lag	sec	The true lag between the Oracle GoldenGate Replicat and its data source
Replicat Position	Load	Operations Rate	ops/sec	The total of DML (insert, update, delete), DDL (table definition) and truncate changes per second
Replicat Position	.	Last Operation Time	NA	The time when an operation was committed in the data source, as recorded in the transaction log
Replicat Position	.	Last Checkpoint Time	NA	The time when the last checkpoint was written by the Oracle GoldenGate process
Replicat Position	.	Checkpoint Position	NA	Composite representation of the checkpoints that were persisted to disk most recently
Replicat Position	.	End Of File	boolean	Shows we reached the end of the input from its data source
Replicat Position	.	Interval	sec	Interval of metric collection
Table Statistics	.	Table Name	NA	Table name
Table Statistics	.	Target Table Name	NA	Target table name
Table Statistics	Load	Insert Rate	per sec	Insert operations performed per second
Table Statistics	Load	Update Rate	per sec	Update operations performed per second
Table Statistics	Load	Delete Rate	per sec	Delete operations performed per second
Table Statistics	Load	Truncate Rate	per sec	Truncate operations performed per second
Table Statistics	Error	Ignore Rate	per sec	Number of errors ignored per second
Table Statistics	Error	Discard Rate	per sec	Number of operations discarded per second
Table Statistics	Interval	sec	Interval of metric collection

Table 1-373 Supported Status and Performance Metrics for GoldenGate Process

Metric Group	Category	Name	Unit	Description
Process Performance	Load	Read I/O Rate	MB/sec	Average number of read I/O per second between last two collections
Process Performance	Load	Write I/O Rate	MB/sec	Average number of write I/O per second between last two collections
Process Performance	Utilization	CPU Utilization	%	Percentage of total CPU time used
Process Performance	Load	Private Memory Size	GB	Amount of private memory used by the process
Process Performance	.	Interval	sec	Interval of metric collection
Packet Statistics	Load	Dropped Packet Rate	per sec	Average amount of dropped packets per second by the process since the last collection interval
Packet Statistics	Load	Missing Packet Rate	per sec	Average amount of missing packets per second by the process since the last collection interval
Packet Statistics	Error	Error Packet Rate	per sec	Average amount of error packets per second by the process since the last collection interval
Packet Statistics	Load	Packet Receive Rate	per sec	Average amount of received packets per second by the process since the last collection interval
Packet Statistics	.	Interval	sec	Interval of metric collection