Returns performance-related statistics for Replication Agent components or resets statistics counters.
ra_statistics [component|reset]
The optional keyword that identifies a Replication Agent component. Valid component keywords are:
LR – Log Reader component
LTI – Log Transfer Interface component
LTM – Log Transfer Manager component
The optional keyword that resets statistics counters.
ra_statistics
This command returns performance statistics for the Replication Agent instance.
ra_statistics reset
This command resets the statistics counters for the Replication Agent instance.
If you invoke ra_statistics without specifying a component option, it returns statistics for all Replication Agent components.
If you invoke ra_statistics and specify a component option, it returns statistics for the Log Transfer Manager, as well as the component you specify.
Statistics counters are reset automatically each time the Replication Agent instance goes into the Replicating state.
If you invoke ra_statistics with the reset keyword, Replication Agent immediately resets all statistics, except the following:
Time statistics obtained
Time replication last started
Time statistics last reset
VM total memory
VM free memory
The “VM total memory” and “VM
free memory” statistics values are refreshed each time
statistics are returned.
Last QID sent
Last transaction ID sent
All statistics that give a measurement of time are in seconds.
Table 4-2 lists the statistics that are returned by the ra_statistics command.
Component |
Statistic |
Description |
|---|---|---|
LTM |
Time statistics obtained |
Day, date, and time ra_statistics was invoked and information returned. |
LTM |
Time replication last started |
Day, Date, and time that the Replicating state was entered. |
LTM |
Time statistics last reset |
Day, date, and time statistics counters were reset. |
LTM |
VM total memory |
Total memory (in bytes) allocated to the Java Virtual Machine on which Replication Agent is running. |
LTM |
VM free memory |
Total memory (in bytes) allocated but not used by the Java Virtual Machine on which Replication Agent is running. |
LR |
Number of XLog scans |
Number of times Log Reader scanned transaction log since last reset. |
LR |
Avg unprocessed operations per XLog scan |
Average number of operations not processed for any reason during each log scan. |
LR |
Avg XLog scan time |
Average time required for transaction log scans since last reset. |
LR |
Number of operations replicated |
Number of operations read from transaction log and passed to LTI since last reset. |
LR |
Number of transactions replicated |
Total number of transactions replicated since last reset. |
LR |
Number of XLog operations skipped (maint_user, unmarked tables) |
Total number of maintenance user transactions in primary database skipped and operations with entries pointing to non-existent shadow tables skipped since last reset. |
LR |
Avg wait time on empty XLog |
Average time Log Reader waits for operations to be recorded in the transaction log. |
LR |
Avg PDB Service Time / Operation |
Average Log Reader processing time per replicated operation. |
LR |
Operation Queue Size |
Number of metadata objects in the Log Reader internal queue. |
LR |
Operation Data Hash Size |
Number of data objects in the Log Reader internal data hash table. |
LR |
Number of transactions truncated |
Total number of transactions truncated from transaction log since last reset. |
LTI |
Total bytes sent |
Total number of bytes sent to Replication Server since last reset. |
LTI |
Number of LTL commands sent |
Total number of LTL commands sent to Replication Server since last reset. |
LTI |
Avg LTL commands/sec |
Average number of LTL commands sent to Replication Server per second. |
LTI |
Avg LTL command size |
Average size of the LTL commands sent since last reset. |
LTI |
Avg Rep Server turnaround time |
Average time it takes Replication Server to acknowledge each LTL buffer sent. |
LTI |
Avg Bytes/second during transmission |
Average bytes per second rate over connection to Replication Server. |
LTI |
Avg data arrival time |
Average time LTI waits between receiving change sets from Log Reader. |
LTI |
Avg 16k LTM buffer utilization (%) |
Average utilization of the 16K buffer used to store up LTL output to Replication Server (in percent). |
LTI |
Avg LTL commands/buffer |
Average number of LTL commands per 16K buffer sent. |
LTI |
Input queue size |
Number of change sets in the LTI input queue. |
LTI |
Output queue size |
Number of distributes in the LTI output queue. |
LTI |
Last QID sent |
Hex value of most recent origin queue ID sent to Replication Server. |
LTI |
Last transaction id sent |
Hex value of most recent transaction ID sent to Replication Server. |
LTI |
Avg time to create distributes |
Average time it takes to convert each change set to LTL. |
The ra_statistics command is valid when the Replication Agent instance is in either Admin or Replicating state.
ra_status
