Returns performance-related statistics for Mirror Replication Agent components and the Java Virtual Machine (Java VM), or resets the statistics counters.
ra_statistics [component|reset]
The optional keyword that identifies a Mirror Replication Agent component or the Java VM. Valid component keywords are:
LR – Log Reader
LTI – Log Transfer Interface
LTM – Log Transfer Manager
VM – Java Virtual Machine
The optional keyword that resets the statistics counters.
ra_statistics
This command returns performance statistics for the Mirror Replication Agent instance and the Java VM.
ra_statistics reset
This command resets the statistics counters for the Mirror Replication Agent instance.
If you invoke ra_statistics with no option, it returns statistics for all Mirror Replication Agent components and the Java VM.
If you invoke ra_statistics with a component option, it returns statistics for the Log Transfer Manager component, as well as the component (or Java VM) you specify.
Table 4-2 lists the statistics returned for the Java VM.
Component |
Statistic |
Description |
|---|---|---|
VM |
VM maximum memory |
Maximum memory (in bytes) available to the Java VM |
VM |
VM total memory allocated |
Total memory (in bytes) allocated to the Java VM at start-up |
VM |
VM free memory |
Memory (in bytes) allocated, but not used by the Java VM |
VM |
VM memory usage |
Memory (in bytes) allocated and in use by the Java VM |
VM |
VM % max memory used |
Percentage of the maximum memory available to the Java VM, currently in use by the Java VM |
Table 4-3 lists the statistics returned for the Log Transfer Manager component.
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 Replicating state was entered |
LTM |
Time statistics last reset |
Day, date, and time that statistics counters were reset |
LTM |
Items held in Global LRUCache |
Number of object references in the internal Least Recently Used cache |
Table 4-4 lists the statistics returned for the Log Reader component.
Component |
Statistic |
Description |
|---|---|---|
LR |
Total pages read from log device |
Number of pages read from log devices since last reset |
LR |
Avg rows per page |
Average number of rows per page read from log devices since last reset |
LR |
Last page read |
Block and page number of most recent page read from log devices |
LR |
Total operations scanned |
Number of operations read from log devices since last reset |
LR |
Total operations processed |
Number of operations read from log devices and passed to LTI since last reset |
LR |
Total operations skipped |
Number of operations read from log devices and not processed for any reason since last reset |
LR |
Total maintenance user operations filtered |
Number of Maintenance User operations read from log devices and skipped since last reset |
LR |
Avg operation processing time |
Average Log Reader operation processing time (in milliseconds) since last reset |
LR |
Total transactions processed |
Number of transactions read from log devices since last reset |
LR |
Total transactions skipped |
Number of transactions read from log devices and not processed for any reason since last reset |
LR |
Total transactions opened |
Number of begin transaction commands read from log devices since last reset |
LR |
Total transactions closed |
Number of commit and rollback commands read from log devices since last reset |
LR |
Total transactions committed |
Number of commit commands read from log devices since last reset |
LR |
Total transactions aborted (rolled back) |
Number of rollback commands read from log devices since last reset |
LR |
Total system transactions skipped |
Number of system transactions read from log devices and skipped since last reset |
LR |
Avg ops per transaction |
Average number of operations in each transaction read from log devices since last reset |
LR |
Current scan buffer size |
Current size (in bytes) of the Log Reader scan buffer |
LR |
Current operation queue size |
Current size (in bytes) of the Log Reader input queue |
LR |
Log reposition point locator |
Locator value of reposition point in log device |
LR |
Last processed operation locator |
Locator value of most recently processed operation read from log devices |
LR |
Avg xlog operation wait time (ms) |
Average time (in milliseconds) that Log Reader had to wait for each new operation to appear in the log since last reset |
LR |
Avg sender operation processing time (ms) |
Average time (in milliseconds) that Log Reader sender took to process each operation since last reset |
LR |
Avg sender operation wait time (ms) |
Average time (in milliseconds) that Log Reader sender had to wait to send each processed operation to the LTI input queue since last reset |
LR |
Avg ChangeSet send time (ms) |
Average time (in milliseconds) that Log Reader sender took to send each processed operation to the LTI input queue since last reset |
LR |
Total sender operations processed |
Number of operations that Log Reader sender processed since last reset |
Table 4-5 lists the statistics returned for the Log Transfer Interface component.
Component |
Statistic |
Description |
|---|---|---|
LTI |
Number of LTL commands sent |
Total number of LTL commands sent to Replication Server since last reset |
LTI |
Avg LTL command size |
Average size (in bytes) of each LTL command sent to Replication Server since last reset |
LTI |
Avg LTL commands/sec |
Average number of LTL commands sent per second to Replication Server since last reset |
LTI |
Total bytes sent |
Number of bytes sent to Replication Server since last reset |
LTI |
Avg Bytes/second during transmission |
Average bytes per second sent over connection to Replication Server since last reset |
LTI |
Avg Rep Server turnaround time |
Average time (in milliseconds) it takes Replication Server to acknowledge each LTL command buffer sent since last reset |
LTI |
Avg data arrival time |
Average time (in milliseconds) LTI waits between receiving change sets from Log Reader since last reset |
LTI |
Avg time to create distributes |
Average time (in milliseconds) LTI takes to convert a change-set into LTL since last reset |
LTI |
Avg LTL buffer size |
Average size (in bytes) of each LTL buffer sent to Replication Server since last reset |
LTI |
Avg LTM buffer utilization (%) |
Average utilization (in percentage of LTL buffer size) of each LTL buffer sent to Replication Server since last reset |
LTI |
Avg LTL commands/buffer |
Average number of LTL commands per buffer sent to Replication Server since last reset |
LTI |
Input queue size |
Current number of change sets in the LTI input queue |
LTI |
Output queue size |
Current 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 |
Statistics counters are reset automatically each time the Mirror Replication Agent instance goes into Replicating state.
If you invoke ra_statistics with the reset keyword, Mirror Replication Agent immediately resets all of the statistics, except the following:
Time statistics obtained (LTM)
Time replication last started (LTM)
Time statistics last reset (LTM)
Last QID sent (LTI)
Last transaction ID sent (LTI)
All Java VM statistics
All Java VM statistics are refreshed each time ra_statistics returns statistics
values.
The ra_statistics command is valid when the Mirror Replication Agent instance is in either Admin or Replicating state.
