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.
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, it returns statistics for the Log Transfer Manager component, as well as the component (or Java VM) you specify.
Table 1-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 1-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 1-4 lists the Log Reader statistics for UDB.
Component |
Statistic |
Description |
|---|---|---|
LR |
Number of xlogs scanned |
Number of operations read from log devices |
LR |
Average unprocessed operations per XLog scan |
Average number of unprocessed operations for each XLog scan |
LR |
Average XLog scan time |
Average XLog 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 XLog operations skipped (maint_user, unmarked tables) |
Number of XLog operations that were skipped |
LR |
Average wait time on empty XLog |
Average time that the XLog 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-5 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 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 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-6 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 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 log read time (ms) |
The total time spent reading 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 |
Total archive log read time (ms) |
The total time spent reading primary database transaction log archives |
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 |
Total bytes queued |
The total number of bytes queued |
LR |
Average number of bytes per queued record |
The average number of bytes per queued record |
LR |
Average number of checkpoints per records read |
The average number of checkpoint log records per records read |
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 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 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-7 lists the statistics returned when the primary database is Oracle RAC.
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 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 |
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 |
Table 1-8 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 Replication 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 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 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 |
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 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.
The ra_statistics command is valid when the Replication Agent instance is in either Admin or Replicating state.
