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 |