Returns performance-related statistics for Replication Agent components and the Java Virtual Machine (Java VM), or resets the statistics counters.
The statistics counters may vary by primary database.
ra_statistics [component|reset]
The optional keyword that identifies a 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 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 Table 1-4.
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.
Table 1-4 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 1-5 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 1-6 lists the Log Reader statistics for UDB.
Component |
Statistic |
Description |
|---|---|---|
LR |
Number of transaction logs scanned |
Number of operations read from log devices |
LR |
Average unprocessed operations per transaction log scan |
Average number of unprocessed operations for each transaction log scan |
LR |
Average transaction log scan time |
Average transaction log scan time for operations read from log devices |
LR |
Number of operations replicated |
Number of operations that were successfully replicated |
LR |
Number of transactions replicated |
Number of transactions that were successfully replicated |
LR |
Number of transaction log operations skipped (maint_user, unmarked tables) |
Number of transaction log operations that were skipped |
LR |
Average wait time on empty transaction log |
Average time that the transaction log was not in use |
LR |
Average PDB Service Time/Operations |
Average service and operations time for each database |
LR |
Operation Queue Size |
The queue size used for the operations |
LR |
Operation Data Hash Size |
The data hash size for the operations |
LR |
Number of transactions truncated |
Number of transactions that were truncated |
Table 1-7 lists the Log Reader statistics for Microsoft SQL Server.
Component |
Statistic |
Description |
|---|---|---|
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 operations 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 |
Current session cache size |
Current size (in bytes) of the session cache |
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 |
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 |
LR |
Average sender operation processing time (ms) |
Average time (in milliseconds) that Log Reader sender took to process each operation since last reset |
LR |
Average 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 |
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 |
LR |
Total sender operations processed |
Number of operations that Log Reader sender processed since last reset |
LR |
Marked objects cache size |
Current marked objects cache size |
Table 1-8 lists the statistics returned for the Log Reader component for Oracle.
Component |
Statistic |
Description |
|---|---|---|
LR |
Average RBA search time (ms) |
The average record byte address (RBA) search time during log scanner positioning |
LR |
Total bytes read |
The total number of bytes read from the primary database transaction log |
LR |
Total log records read |
The total number of log records read from the primary database transaction log |
LR |
Average number of bytes read per second |
The average number of bytes read from the primary database transaction log per second |
LR |
Average number of bytes per record |
The average number of bytes per log record read |
LR |
Average time (ms) per log read |
The average time per primary database transaction log read |
LR |
Total online log read time (ms) |
The total time spent reading the primary database online transaction redo log |
LR |
Total archive log read time (ms) |
The total time spent reading primary database transaction redo log archives |
LR |
Average time (ms) per online log device read |
The average time per online log device read |
LR |
Average time (ms) per archive log device read |
The average time per archive log device read |
LR |
Total log records queued |
The total number of log records queued for processing |
LR |
Total log records filtered |
The total number of log records filtered |
LR |
Log scan checkpoint set size |
The current number of log records in the checkpoint set |
LR |
Average number of log records per checkpoint |
The average number of log records for each checkpoint log record read |
LR |
Average number of seconds between log record checkpoints |
The average number of seconds between reading log record checkpoints |
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 of the Log Reader scan buffer |
LR |
Current operation queue size |
Current size of the Log Reader operation queue |
LR |
Current session cache size |
Current size of the session cache |
LR |
Current Op Proc RASD marked object cache size |
Current size of the operation processor marked object repository cache |
LR |
Total number of Op Proc RASD marked object cache hits |
Total number of operation processor marked object repository cache hits |
LR |
Total number of Op Proc RASD marked object cache misses |
Total number of operation processor marked object repository cache misses |
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 |
Average 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 |
Average sender operation processing time (ms) |
Average time (in milliseconds) that Log Reader sender took to process each operation since last reset |
LR |
Average 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 |
Average 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 |
LR |
Number of sender operations processed |
Number of operations that Log Reader sender processed since last reset |
LR |
Current marked objects cache size |
Current marked objects cache size |
Table 1-9 lists the statistics returned when the primary database is Oracle RAC. These statistics exist in addition to the normal Log Reader statistics listed in Table 1-8.
Component |
Statistic |
Description |
|---|---|---|
LR |
Log scan reader current LSN |
The current log sequence number of the log being read for each cluster instance |
LR |
Log scan reader end-of-log status |
The current end of log status for each cluster log scanner |
LR |
Log scan reader last read time |
The number of seconds since the last read for each cluster scanner |
LR |
Log scan record set distribution |
Distribution of the log scan checkpoint set across all log scan threads |
LR |
Log scan reader last record SCN |
The SCN of the last log record read by each cluster scanner |
LR |
Log scan reader checkpoints |
The checkpoint SCN of the last checkpoint log record read by each cluster scanner |
LR |
Log scan checkpoint SCN |
The current checkpoint SCN, based on all cluster scanners |
LR |
Log scan active checkpoint SCN |
The active checkpoint SCN, based on all cluster scanner |
LR |
Total log records read per redo log thread |
The distribution of total log records read across all log scan threads |
LR |
Log scan record set sizes |
The current scan record set size for each cluster scanner |
LR |
Log scan checkpoint queue sizes |
The current checkpoint queue size for each cluster scanner |
Table 1-10 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 |
Average LTL command size |
Average size (in bytes) of each LTL command sent to Replication Server since last reset |
LTI |
Average 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 |
Average Bytes/second during transmission |
Average bytes per second sent over connection to Replication Server since last reset |
LTI |
Average 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 the Replication Server |
LTI |
Average Rep Server turnaround time |
Average time (in milliseconds) it takes Replication Server to acknowledge each LTL command buffer sent since last reset |
LTI |
Average data arrival time |
Average time (in milliseconds) LTI waits between receiving change sets from Log Reader since last reset |
LTI |
Average time to create distributes |
Average time (in milliseconds) LTI takes to convert a change-set into LTL since last reset |
LTI |
Average LTL buffer size |
Average size (in bytes) of each LTL buffer sent to Replication Server since last reset |
LTI |
Average LTM buffer utilization (%) |
Average utilization (in percentage of LTL buffer size) of each LTL buffer sent to Replication Server since last reset |
LTI |
Average LTL commands/buffer |
Average number of LTL commands per buffer sent to Replication Server since last reset |
LTI |
Encoded column name cache size |
Current encoded column name cache size |
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 Replication Agent instance goes into Replicating state.
If you invoke ra_statistics with the reset keyword, 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 you invoke ra_statistics.
All queue, buffer, and cache size statistics are also refreshed and
are not reset in the way averages or sums are reset.
The ra_statistics command is valid when the Replication Agent instance is in the Admin, Replicating, or Replication Down state.
