Returns performance-related statistics for Replication Agent components and the Java Virtual Machine (Java VM), or resets the statistics counters.
ra_statistics
This command returns performance statistics for the Replication Agent instance and the Java VM.
ra_statistics reset
This command resets the statistics counters for the Replication Agent instance.
ra_statistics VM
This command returns statistics for the Java VM as described in the Java VM statistics table.
If you invoke ra_statistics with no option, it returns statistics for all Replication Agent components and the Java VM.
If you invoke ra_statistics with a component option, the ra_statistics command returns statistics for the specified Replication Agent component or the Java VM.
Java VM statistics lists the statistics returned for the Java VM.
Statistic |
Description |
|---|---|
VM maximum memory |
Maximum memory (in bytes) available to the Java VM |
VM total memory allocated |
Total memory (in bytes) allocated to the Java VM at start-up |
VM free memory |
Memory (in bytes) allocated but not used by the Java VM |
VM memory usage |
Memory (in bytes) allocated and in use by the Java VM |
VM % max memory used |
Percentage of the maximum memory available to the Java VM, currently in use by the Java VM |
Log Transfer Manager statistics lists the statistics returned for the Log Transfer Manager component.
Statistic |
Description |
|---|---|
Time statistics obtained |
Day, date, and time when ra_statistics was invoked and information returned |
Time replication last started |
Day, date, and time that Replicating state was entered |
Time statistics last reset |
Day, date, and time that statistics counters were reset |
Items held in Global LRUCache |
Number of object references in the internal Least Recently Used cache |
Log Reader statistics for UDB lists the Log Reader statistics for UDB.
|
Statistic |
Description |
|---|---|
|
Number of transaction logs scanned |
Number of operations read from log devices |
|
Average unprocessed operations per transaction log scan |
Average number of unprocessed operations for each transaction log scan |
|
Average transaction log scan time |
Average transaction log scan time for operations read from log devices |
|
Number of operations replicated |
Number of operations that were successfully replicated |
|
Number of transactions replicated |
Number of transactions that were successfully replicated |
|
Number of transaction log operations skipped (maint_user, unmarked tables) |
Number of transaction log operations that were skipped |
|
Average wait time on empty transaction log |
Average time that the transaction log was not in use |
|
Average PDB Service Time/Operations |
Average service and operations time for each database |
|
Operation Queue Size |
The queue size used for the operations |
|
Operation Data Hash Size |
The data hash size for the operations |
|
Number of transactions truncated |
Number of transactions that were truncated |
|
Total operation process time |
The total time (in seconds) spent running the UDB operation processor thread. |
Log Reader statistics for Microsoft SQL Server lists the Log Reader statistics for Microsoft SQL Server.
|
Statistic |
Description |
|---|---|
|
Total operations scanned |
Number of operations read from log devices since last reset |
|
Total operations processed |
Number of operations read from log devices and passed to LTI since last reset |
|
Total operations skipped |
Number of operations read from log devices and not processed for any reason since last reset |
|
Total maintenance user operations filtered |
Number of maintenance user operations read from log devices and skipped since last reset |
|
Avg operation processing time |
Average Log Reader operation processing time (in milliseconds) since last reset |
|
Total transactions processed |
Number of transactions read from log devices since last reset |
|
Total transactions skipped |
Number of transactions read from log devices and not processed for any reason since last reset |
|
Total transactions opened |
Number of begin transaction commands read from log devices since last reset |
|
Total transactions closed |
Number of commit and rollback commands read from log devices since last reset |
|
Total transactions committed |
Number of commit commands read from log devices since last reset |
|
Total transactions aborted (rolled back) |
Number of rollback commands read from log devices since last reset |
|
Total system transactions skipped |
Number of system transactions read from log devices and skipped since last reset |
|
Avg operations per transaction |
Average number of operations in each transaction read from log devices since last reset |
|
Current scan buffer size |
Current size (in bytes) of the Log Reader scan buffer |
|
Current operation queue size |
Current size (in bytes) of the Log Reader input queue |
|
Current session cache size |
Current size (in bytes) of the session cache |
|
Log reposition point locator |
Locator value of reposition point in log device |
|
Last processed operation locator |
Locator value of most recently processed operation read from log devices |
|
Average transaction log 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 |
|
Avg sender operation processing time (ms) |
Average time (in milliseconds) that Log Reader sender took to process each operation since last reset |
|
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 |
|
Average 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 |
|
Total sender operations processed |
Number of operations that Log Reader sender processed since last reset |
|
Current marked objects cache size |
Marked objects cache size |
Log Reader statistics for Oracle lists the statistics returned for the Log Reader component for Oracle.
Statistic |
Description |
|---|---|
Average RBA search time (ms) |
The average record byte address (RBA) search time during log scanner positioning |
Total bytes read |
The total number of bytes read from the primary database transaction log |
Total log records read |
The total number of log records read from the primary database transaction log |
Average number of bytes read per second |
The average number of bytes read from the primary database transaction log per second |
Average number of bytes per record |
The average number of bytes per log record read |
Average time (ms) per log read |
The average time per primary database transaction log read |
Total online log read time (ms) |
The total time spent reading the primary database online transaction redo log |
Total archive log read time (ms) |
The total time spent reading primary database transaction redo log archives |
Average time (ms) per online log device read |
The average time per online log device read |
Average time (ms) per archive log device read |
The average time per archive log device read |
Total log records queued |
The total number of log records queued for processing |
Total log records filtered |
The total number of log records filtered |
Log scan checkpoint set size |
The current number of log records in the checkpoint set |
Average number of log records per checkpoint |
The average number of log records for each checkpoint log record read |
Average number of seconds between log record checkpoints |
The average number of seconds between reading log record checkpoints |
Total operations scanned |
Number of operations read from log devices since last reset |
Total operations processed |
Number of operations read from log devices and passed to LTI since last reset |
Total operations skipped |
Number of operations read from log devices and not processed for any reason since last reset |
Total maintenance user operations filtered |
Number of maintenance user operations read from log devices and skipped since last reset |
Avg operation processing time |
Average Log Reader operation processing time (in milliseconds) since last reset |
Total transactions processed |
Number of transactions read from log devices since last reset |
Total transactions skipped |
Number of transactions read from log devices and not processed for any reason since last reset |
Total transactions opened |
Number of begin transaction commands read from log devices since last reset |
Total transactions closed |
Number of commit and rollback commands read from log devices since last reset |
Total transactions committed |
Number of commit commands read from log devices since last reset |
Total transactions aborted (rolled back) |
Number of rollback commands read from log devices since last reset |
Total system transactions skipped |
Number of system transactions read from log devices and skipped since last reset |
Avg ops per transaction |
Average number of operations in each transaction read from log devices since last reset |
Current scan buffer size |
Current size of the Log Reader scan buffer |
Current operation queue size |
Current size of the Log Reader operation queue |
Current session cache size |
Current size of the session cache |
|
Total LOB operations processed by query data from PDB |
The total number of LOB operations that have been processed from the primary database |
|
Avg time used to query PDB for LOB operation processing |
The average time taken to query the primary database to process a LOB |
Current Op Proc RASD marked object cache size |
Current size of the operation processor marked object repository cache |
Total number of Op Proc RASD marked object cache hits |
Total number of operation processor marked object repository cache hits |
Total number of Op Proc RASD marked object cache misses |
Total number of operation processor marked object repository cache misses |
Log reposition point locator |
Locator value of reposition point in log device |
Last processed operation locator |
Locator value of most recently processed operation read from log devices |
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 |
Avg sender operation processing time (ms) |
Average time (in milliseconds) that Log Reader sender took to process each operation since last reset |
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 |
Avg change set 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 |
Number of sender operations processed |
Number of operations that Log Reader sender processed since last reset |
Current marked objects cache size |
Marked objects cache size |
Additional statistics for Oracle RAC lists the statistics returned when the primary database is Oracle RAC. These statistics exist in addition to the normal Log Reader statistics listed in the Log Reader statistics for Oracle.
Statistic |
Description |
|---|---|
Log scan reader current LSN |
The current log sequence number of the log being read for each cluster instance |
Log scan reader end-of-log status |
The current end of log status for each cluster log scanner |
Log scan reader last read time |
The number of seconds since the last read for each cluster scanner |
Log scan record set distribution |
Distribution of the log scan checkpoint set across all log scan threads |
Log scan reader last record SCN |
The SCN of the last log record read by each cluster scanner |
Log scan reader checkpoints |
The checkpoint SCN of the last checkpoint log record read by each cluster scanner |
Log scan checkpoint SCN |
The current checkpoint SCN, based on all cluster scanners |
Log scan active checkpoint SCN |
The active checkpoint SCN, based on all cluster scanner |
Total log records read per redo log thread |
The distribution of total log records read across all log scan threads |
Log scan record set sizes |
The current scan record set size for each cluster scanner |
Log scan checkpoint queue sizes |
The current checkpoint queue size for each cluster scanner |
Log Transfer Interface statistics lists the statistics returned for the Log Transfer Interface component.
Statistic |
Description |
|---|---|
Number of LTL commands sent |
Total number of LTL commands sent to Replication Server since last reset |
Avg LTL command size |
Average size (in bytes) of each LTL command sent to Replication Server since last reset |
Avg LTL commands/sec |
Average number of LTL commands sent per second to Replication Server since last reset |
Total bytes sent |
Number of bytes sent to Replication Server since last reset |
Avg Bytes/second during transmission |
Average bytes per second sent over connection to Replication Server since last reset |
Avg LTL buffer cache time |
Average time (in milliseconds) it takes between placing the LTL commands into the LTL buffer to the time it is actually sent to Replication Server |
Avg Rep Server turnaround time |
Average time (in milliseconds) it takes Replication Server to acknowledge each LTL command buffer sent since last reset |
Avg time to create distributes |
Average time (in milliseconds) LTI takes to convert a change-set into LTL since last reset |
Avg LTL buffer size |
Average size (in bytes) of each LTL buffer sent to Replication Server since last reset |
Avg LTM buffer utilization (%) |
Average utilization (in percentage of LTL buffer size) of each LTL buffer sent to Replication Server since last reset |
Avg LTL commands/buffer |
Average number of LTL commands per buffer sent to Replication Server since last reset |
Encoded column name cache size |
Current encoded column name cache size |
Current number of commands in the LTI queue |
Current number of commands in the LTI queue |
Current number of unformatted commands in the LTI queue |
Current number of unformatted commands in the LTI queue |
Last QID sent |
Hex value of most recent origin queue ID sent to Replication Server |
Last transaction id sent |
Hex value of most recent transaction ID sent to Replication Server |
Statistics counters are reset automatically each time the Replication Agent instance goes into Replicating state.
The ra_statistics command is valid when the Replication Agent instance is in the Admin, Replicating, or Replication Down state.